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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
wangfeng9988333
Advocate II
Advocate II

I have date filter and Facility filter, between no relationship. something unexpectly happend

When I replace both date and facility filters, there should not interact with each other, especially since my facility is a single column. When I use the date filter, does the facility filter change from the full list to only two items, then it never turns back to the full list? I could not explain why this happened. For easy to read, I change the facility to a table 

 

wangfeng9988333_0-1692067125054.png

wangfeng9988333_1-1692067178268.png

 

 

1 ACCEPTED SOLUTION

My apologies, but I didn't understand anything.

It would be helpful if you attached an example file.

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

4 REPLIES 4
Ritaf1983
Super User
Super User

Hi @wangfeng9988333 

You can switch off slicer interactions.

Select the slicer with go to format << edit interactions and switch off the second slicer.

you can do the same in the second direction

Ritaf1983_0-1692069555449.png

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Yes, I did switch off slicer interactions with Date. But there is one thing, I have to use a date filter pre-set up the last 30 days on one extra page. When I place this internal filter, my facility changes to 2 items. I could not understand why there was such behavior. The facility has no relationship with the data table. Plus, there is no date field in the facility table. It is purely a single item. 

My apologies, but I didn't understand anything.

It would be helpful if you attached an example file.

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Thank you a lot for your time. I might need to download the new app to see what happened. 

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.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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