Change Sort Order of 100% Stacked Bar, Data Labels

[Anonymous]

In my visualization I have a 100% stacked bar represetning YTD revenue.  The bar is sorted by product name, not product % of revenue.  How can sort this from highest to lowest?

Bonus question, is there a way to represent the percentage and dollar value of each product in a 100% bar?

Thanks!

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

I have tested it and searched some documents. It seems sorting can't be done. Maybe you could vote or submit an idea here: power-bi-ideas.

Maybe there is a workaround: Funnel, which has dollar values and % values. And also it can sort by values. The sizes of items are clear too.

Best Regards!

Dale

[Anonymous]

Thank you @v-jiascu-msft

I too though of the funnel, however visually I think it sends the wrong message.

Additionally, despite the size when you have an significant amount of categories it becomes less discerning.

I have voted for the suggested enhancement, surprised more people have not come across this as a limitation.

Appreciate the feedback.

Thanks!