Matrix Visual representation

[Anonymous]

Hi all,

I have a tricky one (maybe) for you.

I have a large sales transactions fact table organised more or less a follows:

On user selection, I have then to run YoY and by scenario analysis. For example P6YTD FY21 vs same period LY or BDG this year vs actual this year, etc.  The analysis are relatively complex and are aiming to breakdown margin variance by reason:

• Volume variance
• Pricing
• Inflation
• Mix

For doing this I need to compare two periods or two scenarios and for representation I cannot use a matrix visual as only some columns are relevant at year or scenario levels. I need therefore to obtain something like this:

What’s the best way to obtain and represent it in a visual? Maybe creating a temporary table with all the content to be displayed in the visual?

Hope to have been clear enough.

Many thanks in advance.

C.

[PaulDBrown · Accepted solution]

If what you need as columns are all measures, you can use the Field Parameters function. See:
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters 

If the columns are a combination of fields and measures, you could create a custom matrix layout. See:

https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...