Sort Values in a stacked column chart

[Antmkjr]

https://drive.google.com/file/d/1GxPiajMP6seQSnRFa7eLVlJdm9Hvri8w/view?usp=sharing

How to sort the values in a stacked  column chart basd on value. Link to pbix attached.

[v-shex-msft]

Hi @Antmkjr,

You can also take a look at the following blog to create a custom sort table to apply specific sorting order based on the 'sort by column' property and table relationship:

Custom Sorting in Power BI  

Regards,

Xiaoxin Sheng

[NickolajJessen]

Add some sort of index column and use the "Sort by" 

[Antmkjr]

I want to sort by Sal value

[NickolajJessen]

Use index to rank based on sal

Note that this is done on a dimesions table.

Note this cal also be done without the support column: 

RANKX(countries,
    CALCULATE(
    SUM('Table'[Sal])
))

If this post solves your problem, accept it as a solution
Appreciate your kudos

[Antmkjr]

https://drive.google.com/file/d/1GxPiajMP6seQSnRFa7eLVlJdm9Hvri8w/view?usp=sharing

Suppose if i am ranking as below, i am not able to sort the country column.(In real case i have to rank countries,after filtering certain records ,like mentioned below)

Indexj = RANKX('Table',SUMX(CALCULATETABLE(FILTER('Table','Table'[Country]<>"Pakistan"), ALLEXCEPT('Table',Country)),'Table'[Sal]))

Getting the below errror, and hence not able to sort the legends

[NickolajJessen]

Is there anything wrong with the solution i provided?

[Antmkjr]

In the case mentioned above , it is not working?

[NickolajJessen]

Well, you are not trying the solution i provided, haha.

---

@NickolajJessenwrote:

Note that this is done on a dimesions table

---

Also, if you don't want a country to appear, you can just filter it away in your visual. I don't think you need to filter it in your ranking.

[Antmkjr]

This scenario i just gave  as an example, in actual case, there many more filters than this.

Indexj = RANKX('Table',SUMX(CALCULATETABLE(FILTER('Table','Table'[Country]<>"Pakistan"), ALLEXCEPT('Table',Country)),'Table'[Sal]))

In this case it is giving circular dependency error.