Forum Discussion
Adding multiple columns in matrix view
Not sure why this isn't working for you. You should be able to just put the measures into the values well and they should display in the columns.
can you just use a table instead of matrix? Then they have to be in the columns.
screenshot here shows the measures similar to what you want in columns.
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-tables
Hi Carmichael
The ones in the first column are different measures. I need values in the corresponding cells based on row measure and column measure.
| Current week(Measure) | Prior week(Measure) | Same week last month(Measure) | Same week last year(Measure) | Month on Month(Measure) | Year on Year(Measure) | Week on week(Measure) | |
| Sales (Measure) | |||||||
| Profit(Measure) |
Ah - ok....so Measures in both Rows and Columns. Thanks for clarification and for updating your question to make that clear to others.
I would be trying to find a way to get the row measures into calculated columns but that purley because of I have no answer for rows in both Columns and Rows.
I am interested in learning/understanding this myself so I did a quick search and found a few answers all using some variant of switch. The following post has a solution using calculated tables (Cross Join on second solution). Hopefully it might give you an idea to further research.
Please post back here if you do get a slution working for you.
https://community.powerbi.com/t5/Desktop/Table-with-multiple-measures/td-p/1047793