Forum Discussion
Solved
Matrix and weeks
Hi, I am trying to do a very simple task, but in power BI it seems impossible. I have a table with 2 columns, week no. and week name, so 1, Week 1. I apply this and my matrix works, and shows...
Make sure you select the column first - go to the report view, and in fields open the table and click on the column name so it is highlighted
Am I correct in understanding you have a column with just the number, and the other wth the name?
The name is being stored as text, so 10 would become before 2.
To sort by the name, you could:
- click on this column in desktop
- go to modelling tab and use the "Sort by Colum" dropdown
- Select week number
- In the matrix, click the elipse (three dots in the top right), then click the AZ button to reverse the sort order
Hi,
The sort by button is greyed out.
M
Make sure you select the column first - go to the report view, and in fields open the table and click on the column name so it is highlighted
Thanks - it did work but I needed 2 tables, no idea why but it's working so i'll take it!