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!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

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

Top Kudoed Authors