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
1,016 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 858 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
1,876 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
• 33,030 points
10,228 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,490 points
3,526 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
• 33,030 points
8,058 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
3,074 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,520 points
78,594 views
0 votes
0 answers

After connecting SharePoint List with Power BI, and editing data in query, all the data I want are in links

I've try so many ways to decode ...READ MORE

Jun 18, 2020 in Power BI by Dora
• 120 points
1,104 views
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,890 points
587 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,540 points
13,897 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP