Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I need help sorting a 100% Stacked Bar chart using a win rate %. I have the columns set up in the power query. I'm unable to get the chart to sort by the percentage. I've tried using an index column and use the average to sort, but only a few on the ends sort properly, but the middle includes 0% & 100% along with out of order percentages.
What I have:
Account, Closed Won, Closed Lost, Total, Win Rate (%), Win Rate (1.2), and added an index column.
Any help will be greatly appreciated!
Solved! Go to Solution.
Hi @Anonymous ,
Please try like this:
Update:
Sorry that I uploaded the wrong pbix file. Please reference the updated one.
Hi @Anonymous ,
Have you tried it? Does it work for you? If yes, please accept the answer as solution. If you still need help, please share more details to us. We will understand clearly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |