Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
But I would like to get is this :
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
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |