Creating Stacked Column Chart without unpivot of data in Power Query

0 votes
​Hello,

For creating Stacked Column Chart into PBI, I use the below steps :

1. Go to Power Query
2. Create a duplicate column of the field for which I need to update the graph
3. Rename the column to required name
4. Lastly I unpivot the duplicated columns and load the report

I have attached excel for your reference, which shows the table and chart been updated. (currently not able to see upload option)

There are around 6 stacked chart that I need to update to PBI Dashboard.

So for every 6 stacked charts, I again go to PBI and select get data option. So I have 6 data in Fields pane into PBI.

Is there a way a exclude the above steps that I mentioned. I do not want to create duplicate columns by going into Edit Queries.

Sorry. I'm totally new to Power BI, so going through multiple queries.
Jan 21 in Power BI by Prakash
• 140 points
108 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Power BI

0 votes
0 answers

Creating Stacked Column Chart without unpivot of data in Power Query

h READ MORE

Jan 21 in Power BI by Prakash
• 140 points

closed Mar 24 by Sirajul 53 views
+1 vote
1 answer

Stacked and a independent column chart in power BI

Hi Rahul, Follow the below steps: 1. Create a ...READ MORE

answered Jun 12, 2019 in Power BI by anonymous
• 32,460 points
2,639 views
0 votes
1 answer

Select Columns from table instead of removing afterwards in Power Query

Try this. let db = Sql.Databases("sqlserver.database.url"){[Name="DatabaseName"]}[Data], Sales_vDimCustomer = ...READ MORE

answered Oct 31, 2018 in Power BI by Shubham
• 13,380 points
701 views
0 votes
1 answer

How can I get a column value from previous row in Power Query?

Hi Sindhu, add this line as your ...READ MORE

answered Mar 18, 2019 in Power BI by Cherukuri
• 32,460 points
3,396 views
0 votes
1 answer

Cumulative row data over last 12 months in Power Query

Basically, what you do is,  Add an Index,  Group ...READ MORE

answered Apr 1, 2019 in Power BI by Upasana
• 8,590 points
708 views
0 votes
1 answer
+1 vote
1 answer

Is there a way to convert JSON data to readable table in power bi

Follow these steps step 1 - Click on ...READ MORE

answered Sep 24, 2018 in Power BI by Hannah
• 18,040 points
6,140 views
0 votes
1 answer

Can I create a Power BI report in Office 365 without my locally installed Office Excel?

Yess!! You can achieve this by using ...READ MORE

answered Sep 26, 2018 in Power BI by Kalgi
• 51,850 points
174 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,200 points
970 views
+1 vote
1 answer

Have column with multiple values in powerBI, for use with a slicer in power bi

It can be achieved depending on the result you ...READ MORE

answered Oct 22, 2018 in Power BI by Hannah
• 18,040 points
3,603 views