Forum Discussion
Matrix Column mangement
Hi there,
I have a small and simple question (I think) about column management in a Matrix visual
Below are the data I have added to my visual
Rows:
- Range
- Product
Columns:
- Year
Values :
- Quantity
- Sales
Below this is the Matrix I have in PBI
Initial Matrix
But I would like to get is this :
Wanted result
However I can't get this visual and I don't know how to do it.
Does anyone have a simple idea?
Thanks a lot,
Kind regards
PierreL69 , the second screenshot means the measure is above and the year is below
You can do that using calculation group
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display: https://youtu.be/qMNv67P8Go0
3 Replies
PierreL69 , the second screenshot means the measure is above and the year is below
You can do that using calculation group
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display: https://youtu.be/qMNv67P8Go0
