Reply
inesj
Frequent Visitor

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:

inesj_0-1712331658170.png

So far I have created a field parameter, which I have then placed into a slicer:

 

inesj_1-1712331827020.png

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!

 

1 REPLY 1
adudani
Super User
Super User

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)

 

 

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a Kudos 🙂
Kind Regards,
Avinash
avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)