Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

Matrix Visual not getting filtered based on slicer selection

Dear All,

 

I am facing an issue with a matrix visual coming from one pivot table wherein I have 3 slicers coming from another pivot table. 

My requirement is that the matrix should show only those columns which are selected in those slicers. But still the matrix visual remains static without getting filtered once I select something from the slicers.

A many-to-many relationship was auto detected between those columns. To avoid many to many relationships, I created a bridge table and linked this bridge table with other two tables via a many-to-one relationship with cross-filter direction as single. I tried by setting it to both also.

Neither of the above suggested approaches didn't work.
Please suggest if there is an alternative to fix this issue.

 

Regards,
Saichandar.

 

 

3 REPLIES 3
Mahesh0016
Super User
Super User

@Anonymous Please Reffer Below Link I hope this helps you!THANK YOU!!

topics field parameters :  Fields Parameter in Action I Practical Examples - YouTube 

Anonymous
Not applicable

Dear Mahesh, 
Thank you for your inputs, but this unfortunately didn't work. Since all the tables I have are pivot tables with column names as Attribute, Atrribute1, Value, Value1 and so on..

Anonymous
Not applicable

I actually tried and the matrix visual blanks out if I select anything from the field parameter slicer. Is there something to do with the relationships between the parameters? I tried establishing relationships but it didn't work.

 

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! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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