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.

     

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.