Forum Discussion
Sort Values in a stacked column chart
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)
Getting the below errror, and hence not able to sort the legends
Is there anything wrong with the solution i provided?
In the case mentioned above , it is not working?
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.
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.