TreeMap vs Stacked Bar

[W4LTZ]

Hi guys,

Not sure how to get around this one and your help would be much appreciated.

I'd like a visual that can group the quantity percentages with the group averages such as on the TreeMap below.

However, i'd like the data to show like on the below from excel, with bars in a descending sort for average and the group percentage in the X-axis.

I've tried the playing with the stacked bar chart but no luck....

Any help would be greatly appreciated.

Cheers

[Anonymous]

Hi @W4LTZ ,

You can create a stacked column chart and sort Y-axis with descending order just as below screenshot.

Power BI - Stacked Column Chart Example - Power BI Docs

Stacked Column Chart in Power BI 

If the above one can't help you get the expected result, please provide some raw data in your tables (exclude sensitive data) with Text format and your visual settings. It would be helpful to find out the solution. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[W4LTZ]

Thanks for the response v-yiruan-msft.

My issue is not with the sorting of the data in the Stacked Column chart. It's the width of each bar in the x-axis that needs align with a series - in this case the proportion of each group (1, 2, 3, 9 and 10 on the chart in my original post) against their total quantity.

So basically both axes y and x need to be driven by a series. I've managed to replicate it in excel and it was a considerable amount fo work.

The link below explains exactly what i'd like PBI to do:

https://www.youtube.com/watch?v=jEcShc1Nyeg

Again, i appreciate the help. Hopefully this additional info helps.

Cheers