Forum Discussion
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.
Hello Mr. Danextian.
Here's the link: Google Drive
If possible, I want to have the Dates under the Main Metrics (Spend, Sales, Orders).
The dates are limited only to 4 columns because our team needs to monitor the current week up to last month that's why we only need 4 columns of Dates. And also it should be in weeks format. Please see photo below.
Thank you!!
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.
Thank you!!
Last question, how can I add a conditional formatting where it will become red when the value is greater/lesser than the previous date? Let's say our sales this week is $100 and last week was $500. The ($100) cell should highlight red.
Edit:
I tried conditional formatting but I think it will not work because we unpivoted the columns of metrics. So the values of a specific metric (Orders, Sales, Spend) cannot be compared to the other date column because they use a single column only (Metrics) inside the tableFor 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.
I'm very grateful to you, and to this community. Such a BIG help!
All the best to MS Power BI Team! 🙂