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
Solved! Go to Solution.
@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
@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
Do you have maybe something less complex and more focused on what I am trying to do ?
I am trying to find a solution on google but wihtout success 😞
Thanks
Ouch seems complicated I thought there was something simple
I'll try to digest this video, to try to come up with something
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
104 | |
73 | |
71 | |
47 | |
47 |
User | Count |
---|---|
160 | |
85 | |
80 | |
68 | |
67 |