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, 2020 in Power BI by Prakash
• 140 points
398 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, 2020 in Power BI by Prakash
• 140 points

closed Mar 24, 2020 by Sirajul 188 views
0 votes
1 answer

Creating a stacked chart from 1 column in Power BI

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

answered Aug 3, 2020 in Power BI by Reshma
170 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,970 points
6,188 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,480 points
1,786 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,970 points
5,561 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,620 points
1,264 views
0 votes
3 answers

How to add an extra column to the existing table in power bi query editor?

Click on edit queries after loading source ...READ MORE

answered Dec 16, 2020 in Power BI by Roshni
• 10,480 points
22,173 views
0 votes
0 answers
0 votes
1 answer

Format Data to tabular structure in Excel - Power m Query - Excel

Hi, @Kiranbvsn You can check this out: https://www.howtoexcel.org/ ...READ MORE

answered Oct 27, 2020 in Power BI by Gitika
• 65,910 points
112 views
+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,560 points
10,579 views