Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
Solved! Go to 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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
144 | |
73 | |
64 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |