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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
tybmf
Frequent Visitor

Slicer not working

Hi,

I have 2 slicers on a page one for date and one resource. I also have two different tables, date and resource work for one table, but only date is working for the other. I have checked interactions and they seem to be fine. The only way I have been able to get it to work is to add an additional slicer for resource linking it only to the one table.

 

Thanks

6 REPLIES 6
Greg_Deckler
Community Champion
Community Champion

Not sure from your description. Perhaps you have a relationship direction wrong? Would reall need to see a picture of your model with identification of what you are using for slicer, etc.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Power Bi.png

Anonymous
Not applicable

Have you tried changing the relationship's for the resources table to "both" directional?

Still not having any luck with it. Resource still isn't filtering the downtime.

 

Thanks

 

 

image.png

Anonymous
Not applicable

Try also changing the relationship between resources1 and data to both. 

No luck. If I filter Both and Many to Many it doesn't return any data in my downtime visual. If I choose Both and Many to One it returns all the downtime unfiltered.

image.png

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.