- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Matrix Headers Based on Slicer Selection
Hello!
I have a matrix displaying the average scores given by participants on different questions in a yearly survey. I would like users to be able to choose which column headers to display, so that they can compare results under different perspectives (i.e. by Year, by Business Unit, by Supplier, etc.). They should also have the possibility to select more than one dimension, and have them both displayed as headers. For example, selecting "By Year" and "By Business Unit" should show the following:
So far I have created a field parameter, which I have then placed into a slicer:
This is kind of working, but selecting more than one dimension only displays 1 header in the matrix (the first one selected). The user is then able to drill down on the columns of the matrix to see the other selected levels, but this is quite inconvenient - they would like to see all headers at once.
Is there any way to fulfill this requirement?
Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi @inesj ,
maybe calculation groups are more appropriate for this. For more context ((Case Study) Field Parameters or Calculation Groups??? (youtube.com) )
Some use cases that maybe applicable : 3 Ways to use Calculation Groups You Need to Know (youtube.com)
If my response(s) assisted you in any way, don't forget to drop me a Kudos 🙂
Kind Regards,
Avinash

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
09-01-2024 06:24 PM | |||
08-15-2024 11:33 AM | |||
10-01-2024 07:50 AM | |||
10-16-2024 04:27 PM | |||
08-21-2024 12:51 PM |
User | Count |
---|---|
86 | |
79 | |
42 | |
40 | |
35 |