sort 100% stacked bar chart by measure

[vin123]

Hi,

I've read this thread https://community.powerbi.com/t5/Desktop/Sort-100-Stacked-Column-Chart-by-Percentage-Values/m-p/3263...

but am finding it hard to apply to my own situation, although I imagine it's similar.

I just want to sort these data by the % of highly cited papers in each journal.

I have another categorisation, which is called ESI field, and sits in the slicer. So for whatever ESI field is selected, I'd like the bars to be sorted by journal % of highly cited papers descending.

My data structure is this:

and I've put both Total Docs and Highly Cited Papers in the Value section.

I also tried to unpivot this data such that the Total Docs and Highly Cited Papers would be an Attribute, so each journal would have 2 rows. But same thing occurs when I put the attribute as the legend, and I can't figure out a way to sort by the largest % of Highly Cited Papers.

Any help would be appreciated!

[amitchandak]

@vin123 , Go to three dots and sort the required measure/column and check if it works

[vin123]

Hi @amitchandak 

Thanks for replying, this had already been selected as below:

any ideas?

[vin123 · Accepted solution]

I managed to figure this out by creating the percentage measures propHiCi and propNotHiCi and then putting these as the values instead of the actual numbers. Then I could sort by the percentage I wanted to.