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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Nazdac911
Helper II
Helper II

The relationship between slicer status and visual filtering

Hi all 

I am using a simple measue to detect whether a slicer colum is filteres or not : 

_is_product_filtered =
CALCULATE(
    IF(
        ISFILTERED(Dim_product[product_name]) , 1 , 0) ,
        ALLSELECTED(Dim_product[product_name])
)
or 
INT(
    NOT (ISBLANK(SELECTEDVALUE(Dim_product[product_name]) ))
 
And then I am applying this filter on my visual , I notice that it work great with some visuals but its not working with others (just like labels ) 
Nazdac911_0-1670503332727.png

and also why I cant apply one filter to the whole page ? 

Is their is a rule for that ? 
Thanks in advance 
regards 
2 REPLIES 2
amitchandak
Super User
Super User

@Nazdac911 , allselected should always work

 

_is_product_filtered =
int(CALCULATE(
ISFILTERED(Dim_product[product_name]) ,
ALLSELECTED(Dim_product[product_name])
))

Hi Mitchendak 
thank you for the new script , but this also cant apply to label visual ?

regards 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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