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,

 

This should be possible.  Share the link from where i can download your PBI file.

  • 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.

    • 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.