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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
gpaula
Frequent Visitor

Use a slicer visual to filter a matrix which filter another slicer visual

Hi masters.

 

I really struggle on that. I have a model that i use a single column table to create a slice who filter everything else. And a have another segmentation in slice visual that use to filter the whole report too. Beside that i have a matrix where the rows is the first slice visual values and the columns is the second slice values as i mentioned and the cells values are zero or one. When you select one value in the first slice i want the second slice automatic selected the values where in the matrix has values equals one but not disappear with the other options whom not be selected. Can i achieve that with measure? I try with relationships, selectvalue measure and calculate table  but with no sucess.

 

Help me plz, i need that for yesterday. Thx!

5 REPLIES 5
gpaula
Frequent Visitor

Anyone to help me plz?

Anonymous
Not applicable

Hello @gpaula 
You can refer to the link .
I believe this will resolve the query.

 

It isnt work for me.

 

I need the first slice value select in the matrix the correspondents values and it filter the second slicer. Here is a picture from my model.

 

2021-10-29_14-59-27.jpg2021-10-29_14-56-20.jpg

amitchandak
Super User
Super User

@gpaula , Based on what I got

 

If you want a matrix of the table to filter a slicer, you can use a measure from related fact as visual level filter and check for nonblank value

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

How? Can you explain me plz?

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors