Forum Discussion
MattN4
Helper I
Helper IMatrix 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
SteveCampbell
Memorable Member
Memorable MemberAm 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
MattN4Hi,
The sort by button is greyed out.
M
- SteveCampbell
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
- MattN4
Thanks - it did work but I needed 2 tables, no idea why but it's working so i'll take it!