Sort 100% bar chart based on length of bar

[Veena_Narayanan]

I have a 100% stacked bar chart based on 5 parameters, 2 of which are measures which gets calculated based on my slicer selection.

I want to sort the bar chart based on the length of the bar (%).

I am unable to create a new table with the percentages in it & sort the column based on that as the 2 columns for measures shows up as 0 and the percentage that i get is wrong.

I want this chart to be sorted based on the length of the green bar.

[v-eachen-msft · Accepted solution]

Hi @Veena_Narayanan ,

You could sort data by referring to this column chart post.

[amitchandak]

Please refer: https://community.powerbi.com/t5/Desktop/100-Stacked-bar-chart/m-p/905132

https://community.powerbi.com/t5/Desktop/100-Stacked-bar-chart-display/m-p/853213

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin

[Veena_Narayanan]

Thanks @amitchandak  but this is not the solution I am looking at.

I have the stacked bar chart, which sorts the chart based on the TER value, but i want the same to be sorted as percentage which is displayed in the chart. So my graph should have the MS with highest TER% on top & lowest at bottom.

I tried creating a new table & adding a column to calculate the percentage, but it is not calculating it correctly because 2 of the 5 metrics are measures (values are derived based on slicer in dashboard).