Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Sort Values in a stacked column chart

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.    
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

In the case mentioned above , it is not working?

NickolajJessen's avatar
NickolajJessen
Solution Sage
4 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.