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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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