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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

How to block the affect of the filter to the slicer

Hi all,

 

I have a slicer showing the time supposed  until today June 16th, but the slicer is effected by a filter, so it shows only till June 12th. I am wondering how to block the link between slicer and filter?

Thank you!

 

babyjb123_0-1655397015928.png

 

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @Anonymous,

Currently, you can't directly custom with the interaction from different level filters to the slicer.
I'd like to suggest you create an unconnected table with required values and use its field as the source of the slicer.

It should not interact with different level filters and you can set 'visual level filter' with measure expression to apply filter effects from this unconnected table.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

Hi @Anonymous,

Currently, you can't directly custom with the interaction from different level filters to the slicer.
I'd like to suggest you create an unconnected table with required values and use its field as the source of the slicer.

It should not interact with different level filters and you can set 'visual level filter' with measure expression to apply filter effects from this unconnected table.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
speedramps
Super User
Super User

Try move the filters.
Filters can be applied on the visual, in the page or on all pages.

It does what it says in the tin! See attached diagram

 

I have helped you, now please help me by giving kudos.

Click the thumbs up and accept as solution button. 

One question per ticket please. If you need to extend your request then please raise a new ticket.

You will get a quicker response and each solver will get the kudos they deserve. Thank you !

 

 

 

speedramps_0-1655398071677.png

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.