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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

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
Super User
Super User

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!:
Power BI Cookbook Third Edition (Color)

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
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

May 2025 Monthly Update

Fabric Community Update - May 2025

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