Forum Discussion
Matrix Visual representation
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.
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-parametersIf the columns are a combination of fields and measures, you could create a custom matrix layout. See:
1 Reply
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-parametersIf the columns are a combination of fields and measures, you could create a custom matrix layout. See: