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!
I'd like to know if anyone knows a way to use the Matrix object with multiple columns grouped without drilldown. Example:
Group 1 Name 1 Value 1
Group 1 Name 2 Value 2
Group 2 Name 3 Value 3
Group 2 Name 3 Value 4
Group 3 Name 4 Value 5
In the table above, Group 1 should not repeat since it would be grouped.
Group 2 Name 3 as well.
I would not like to use the drilldown option. It's possible?
Thank you very much
Solved! Go to Solution.
Hi,
I think what you are looking for is under Format -> Row Headers and then make sure Stepped layout is Off. Then you can click "at the lowest level of data" at the top left corner on the matrix.
Br,
Gustav
Hi, thank you for your feedback and your help. But I did not understand and could not find where the "format" option is located. Could you send a picture to help me?
My Desktop is in Spanish, but the option are the same.
Perfect. Thanks for your help!
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 |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |