Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
User | Count |
---|---|
80 | |
77 | |
63 | |
48 | |
44 |
User | Count |
---|---|
101 | |
43 | |
39 | |
39 | |
36 |