Forum Discussion
Complex multiple measure Matrix
Hi all,
Long time lurker, first time poster.
I have a need to create a matrix that displays data in an identical way to the image included.
The closest I have come to replicating this is found in the following thread: https://community.fabric.microsoft.com/t5/Desktop/Combine-multiple-measures-in-a-single-matrix/td-p/2170694
Using this, I have made a "Row" table and "Category" table. The Rows correspond with Row 1-4. Category is Month, Year to Date and Full Year forecast. Finally, I was picturing using measures for Actual, Budget, Variance.
I have included a snip of my current attemp (don't mind the numbers as I was attempting to use IF statements with not much success.
I thought something like:
But this works once and doesn't really help me populate the rest of the table.
Any help appreciated.
Snip of what I'm trying to create in Power Bi vvv
Power Bi attemp vvv
2 Replies
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi AWK7 ,
Can you please share some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
