How to switch Columns and Values Headers (Matrix Table)

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.