cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ahmet_Oz
Helper III
Helper III

Stacked Bar Chart with 2-3 Values

Hello everyone,

 

I would like to have multiple %100 stacked bars showing different "Values" 

 

I have created this visual. 

 

Ahmet_Oz_0-1615480772446.png

 

 

I need to put another value and have a stacked bar in the same visual. Is it possible? Example below:

 

Ahmet_Oz_1-1615480823284.png

 

 

Thank you,


Regards,

 

Ahmet

1 ACCEPTED SOLUTION
v-cazheng-msft
Community Support
Community Support

Hi, @Ahmet_Oz 

You need transform the query related with the table creating visual in Power Query Editor.

 

1 Use Headers as First Row

v-cazheng-msft_0-1615792322785.png

 

2 Transpose

v-cazheng-msft_1-1615792322794.png

 

3 Use First Row as Headers

v-cazheng-msft_2-1615792322804.png

 

Then use the new table to create visual, the result looks like this:

v-cazheng-msft_3-1615792322806.png

Here is the pbix.

 

Best Regards,

Caiyun Zheng

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

1 REPLY 1
v-cazheng-msft
Community Support
Community Support

Hi, @Ahmet_Oz 

You need transform the query related with the table creating visual in Power Query Editor.

 

1 Use Headers as First Row

v-cazheng-msft_0-1615792322785.png

 

2 Transpose

v-cazheng-msft_1-1615792322794.png

 

3 Use First Row as Headers

v-cazheng-msft_2-1615792322804.png

 

Then use the new table to create visual, the result looks like this:

v-cazheng-msft_3-1615792322806.png

Here is the pbix.

 

Best Regards,

Caiyun Zheng

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.