Forum Discussion
Solved
How to switch Columns and Values Headers (Matrix Table)
Good day! I've been searching the net and can't find the solution. Can you guys help me how to switch the places of Columns and Values. I have multiple excel files for different types of reports...
Hi muji0317 ,
It seems that you were already in the right direction so I am a bit confused of what you really want to achieve. If you want the metrics to be under the date you can just re-order the fields in column tiles. Please see attached pbix.
Also, I cant open Business Reports (total) file. Error says not in the right format.
For easier time intelligence calculations, it is a good practice to use a separates dates table. You can create one using DAX based on the existing tables in your data model. Please see attached updapted pbix.
