Forum Discussion

grkanth81's avatar
grkanth81
Icon for Helper II rankHelper II
8 years ago
Solved

Sort column Headers in a Matrix

Hi Guys, Can we control the sorting for the column headers in a matrix ?The row and the column sorting should be done based on other columns (here i ahve created 2 new columns in the data model Empl...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    You may refer to my solution in this PBI file.

     

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

You may refer to my solution in this PBI file.

 

Hope this helps.

 

  • grkanth81's avatar
    grkanth81
    Icon for Helper II rankHelper II
    8 years ago

    Thank you Ashish.

    That worked perfectly.

     

    One more small question. Is it possibe to rename the column Total as Employees Total ?

     

    Thannks again.

     

    Ravi....

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      8 years ago

      You are welcome.  No, i don't think that is possible.

      • grkanth81's avatar
        grkanth81
        Icon for Helper II rankHelper II
        8 years ago

        Thanks Ashish.

  • lelabet's avatar
    lelabet
    Icon for Advocate I rankAdvocate I
    6 years ago

    Thank you, Ashish, for the example file. I used it to model my own data and it worked. 

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      6 years ago

      You are welcome.

      • pbiforum123's avatar
        pbiforum123
        Icon for Post Patron rankPost Patron
        6 years ago

        1. Created Category/Employee table

        2. Linked the above tables to the FACT table

        3. Created Category/Employee column in the FACT table.

         

        I have replicated the above steps same like yours but it is still not working. Not sure what has been missed out. Please kindly let me know what is that i have missed out here.