Forum Discussion

grkanth81's avatar
grkanth81
Helper 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.

     

pbiforum123's avatar
pbiforum123
Post 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.