Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi All,
I would like to have a simple matrix view where you can see the YOY change. I have created below table for time being where I calculate all the measures but want to have it in a simple view as the matrix shown below. Please help! 🙂
Table
This Year Quantity | This Year Turnover | Last Year Quantity | Last Year Turnover | Diff Quantity | Diff Turnover | |
Customer A | 100 | 300 | 70 | 200 | 30 | 100 |
Customer B | 120 | 350 | 130 | 370 | -10 | -20 |
Customer C | 90 | 280 | 95 | 275 | -5 | 5 |
Matrix
2018 | 2017 | Difference | ||||
Quantity | Turnover | Quantity | Turnover | Quantity | Turnover | |
Customer A | 100 | 300 | 70 | 200 | 30 | 100 |
Customer B | 120 | 350 | 130 | 370 | -10 | -20 |
Customer C | 90 | 280 | 95 | 275 | -5 | 5 |
Hi @Wesleyvanv,
It seems that the values in table visual are measures except the customer column?
Do you have another date column or date table?
If you have date column, you could create matrix using Custom column as Row, Date column as Column and measures as value.
If you still need help, please share your data sample so that we could help further on it.
Best Regard,
Cherry
Hi @v-piga-msft,
Please find below the pbix with the current matrix, the table as temp solution and the preferrable matrix.
Hope you can help me out with this!
Thanks
Wes
Hi @Wesleyvanv,
For your requirement, I'm afraid that we may not achieve your desired output directly in power bi.
Here is a workaround which is not the best but it's a choice.
You could turn off the word warp of Column header and values under formatting. Then drag the column width like the image above. The 2018-2017 is a shape of rectangle.
More details, please refer to the attachment.
Best Regards,
Cherry
Hi @v-piga-msft,
Thanks for this, I had already done this workaround and it works with two measures in this example, but I have a matrix with 4 measures and then it looks a bit messy. Anyway I think I should just make it not to difficult and go for the table solution or workaround.
Thank you for helping.
Wes
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
142 | |
71 | |
64 | |
52 | |
50 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |