The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a matrix with looks something like this:
Year 1 | Year 2 | Year 3 | ||||
Material | Measure 1 | Measure 2 | Measure 1 | Measure 2 | Measure 1 | Measure 2 |
Material A | 100 | 0% | 110 | 10% | 150 | 36% |
Material B | 100 | 0% | 150 | 50% | 200 | 33% |
Material C | 200 | 0% | 210 | 5% | 230 | 10% |
but i want to create something like this, where i see each measure together, i.e. I want to switch the priority of years and the measures. Is this possible with a matrix?
The year is currently in the "columns", and the measures are in the "values".
Year 1 | Year 2 | Year 3 | Year 1 | Year 2 | Year 3 | |
Material | Measure 1 | Measure 1 | Measure 1 | Measure 2 | Measure 2 | Measure 2 |
Material A | 100 | 110 | 150 | 0% | 10% | 36% |
Material B | 100 | 150 | 200 | 0% | 50% | 33% |
Material C | 200 | 210 | 230 | 0% | 5% | 10% |
Thanks, James
Interested to know if this can be done today, in Jun'2022.
The earlier best answer says.. it wasn't possible then.
@jhd I guess you have measure 1 and 2 on values, unfortunaltey you cannot change the look the way you want, it is going to show each measure from value section for each column.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.