Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I'm working on a matrix about product prices and their difference with the previous month, so far I managed with no problem to get this matrix:
Month | 1 | 2 | 3 | 4 | |||||||
Customer | Origin | Brand | Product | Price | Diff | Price | Diff | Price | Diff | Price | Diff |
A | A | A | Product1 | 10 | 0% | 10 | 0% | 12 | 20% | 12.6 | 5% |
A | A | Product2 | 5 | 1% | 6 | 20% | 6 | 0% | 9 | 50% |
In this, the month is the column, and the Price and Diff are the values.
The problem is that my boss wants something a little different, but I cannot find a way to do it.
Does anyone have any suggestions?
My boss wants to be like this:
Month | Price | Diff | |||||||||
Customer | Origin | Brand | Product | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 |
A | A | A | Product1 | 10 | 10 | 12 | 12.6 | 0% | 0% | 20% | 5% |
A | A | Product2 | 5 | 6 | 6 | 9 | 1% | 20% | 0% | 50% |
Solved! Go to Solution.
You could also potentially use a calcuation group for the price, diff calcs, then you should be able to put the calculation items where ever you like in the matrix.
You could also potentially use a calcuation group for the price, diff calcs, then you should be able to put the calculation items where ever you like in the matrix.
Thank you, that solved my problem!!
Regards,
This can be done but it will be painful and a lot of work.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |