Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Sort Column in a matrix by another column

https://drive.google.com/file/d/1kJpyOsEsR5Yl-xr0nUY7Ds-mJNT-bMXe/view?usp=sharing   How to sort the column in matrix ,in this case Business Unit ,by Salary (The Business Unit with highest sa...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Brilliant !

One more question, if we are putting a filter on department, how to still make it work?

 

 

v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi  Anonymous ,

 

Sorry,I couldnt find a good way to realize it,currently matrix only support column ranking,row ranking can only be fixed by my trick.

I can only do a ranking measure to show the ranking,but I cant make it rank dynamically per your request：

measure_Rank = IF(ISINSCOPE('Human Resources'[Departmets]),BLANK(), RANKX(ALLSELECTED('Human Resources'[Business Unit]),CALCULATE(SUM('Human Resources'[Salary]),ALLEXCEPT('Human Resources','Human Resources'[Business Unit],'Human Resources'[Departmets])),,DESC,Dense))

Check my .pbix file attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks alot for your time, let us wait and see if someone can help any further!

    • v-kelly-msft's avatar
      v-kelly-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi  Anonymous ,

       

      I have a deep thought about this case,and I'm 99% sure that columns cant be sorted dynamically based on selection in matrix.

      You could propose your idea with comments via below link to make this function realize soon.

      https://ideas.powerbi.com/ideas/

       

       

      Best Regards,
      Kelly

      Did I answer your question? Mark my post as a solution!