Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Custom sort column variables in matrix table visual based on a selection

Hi All, I am new to Power BI and self learning. I am trying to replicate a table that I have build in Excel. The table has 4 column geographic variables - Suburb, Area, Division and State. I have se...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    Hi Anonymous ,

     

    take a look at the attached PBIX.

     

     

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi Anonymous ,

 

take a look at the attached PBIX.

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi mwegener,

 

Greatly appreciate your response and thanks a ton for the solution. Your method worked like a charm. Very clever. You are amazing. 

 

You have saved me a lot of time. I worked out a way which was very clunky and a lot of repetition of the data which was not ideal. 

 

 I can't thank you enough for your help. Stay safe. 

 

Regards.