Forum Discussion

Anonymous

Not applicable

8 years ago

Column sorting in matrix visual - Sort By Column not working

I am using the Matrix visual Trying to sort by a column that is not shown in the Matrix. I applied sorting at the Data Model, but this is having no effect on the Visual level. This is what I am tryin...

Icon for Resolver I rank

Resolver I

8 years ago

Anonymous

can you provide a sample of your data?

Anonymous
Not applicable
8 years ago
Some sample data. First I tried creating a calculated column at the Model Level to convert MM/DD/YYYY (Datetime in SQL) to MMM YYYY (Eg. Aug 2018...). This didn't work. I removed the calculated column and actually created similar column but in SQL code. Column is correctly displayed in the Data Model (see above), and the sort is correct (by the actuall full MM/DD/YYY descending order, see above). Nothing seems to work. It seems like only if a column is actually shown in the visual will the visual sort by it.

Notes :

Using Power BI Desktop RS/PBIRS March 2018 version.
Using the Matrix visual.
- v-danhe-msft
  Microsoft Employee
  8 years ago
  Hi Anonymous,
  Based on my test, you could use the "Sort by Column" function.
  Sample data:
  Choose the column you want to sort.
  You can also download the PBIX file to have a view.
  https://www.dropbox.com/s/4rplbfptgglnaaz/Column%20sorting%20in%20matrix%20visual%20-%20Sort%20By%20Column%20disabled.pbix?dl=0
  
  Regards,
  Daniel He
  - Anonymous
    Not applicable
    8 years ago
    Thanks for your feedback. I tried this but it doesn't seem to work with the Matrix visual. I think this is just a limitation (or maybe a bug?) of the Matrix visual.