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
NickolajJessen's avatar
NickolajJessen
Solution Sage
4 years ago

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I want to sort by Sal value

    • NickolajJessen's avatar
      NickolajJessen
      Solution Sage
      4 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        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