cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Abhi21970
Regular Visitor

Matrix in Stack Column chart

 

 

 

Hi, Table.PNG

I tried to show the stack column chart in matrix view which is possible in tableau but I am not able to do it in Power Bi.

 

How to show Stack bar chart in Matrix view in Power BI ?

Mainly I need to see two values in one cell like in stack column chart

In the above image I tried to convert to single matrix view like if you see the Name 10 and value 10 I need to see the countsof A and B in Single cell as stack column chart.

3 REPLIES 3
yingyinr
Community Support
Community Support

Hi @Abhi21970 ,

You can refer the solution in the following threads as a workaround to implement it:

1. Multiple Values for a Matrix can now Appear as Row Headers

yingyinr_0-1633055534710.png

2.  Turning multiple values into one string in Power BI (If the matrix values are Text type)

yingyinr_1-1633055658761.png

If the above ones can't help you get the expected result, please provide some original sample data in your tables and your expected result with the formula of involved measure/calculated column and special examples. Thank you.

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @yingyinr 

 

No this is not a solution I have two different measure which we need to show to one cell like a stack column chart with different colours.

Hi @Abhi21970,

Based on my research, I'm afraid that your requirement (display two field values in one cell cell of the stacked column visual with different colors) is not possible. You can raise a new idea and add your comments there to make this feature coming sooner.

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors