Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
66 | |
62 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |