Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Display whether a filter is selected

Hi there,

 

Desired solution:

A card (or similar) capable of displaying whether the user has made a selection which is creating a cross filtering context on a report page. 

 

Detail: 

 

I currently have a report with a multicard displaying any user selected slicer options. Client is happy with this:

 

Here is the dashboard page. I would like to create a way of reminding the user whether they have selected any particular date within the time series.

 

I now need to do the same, but for scenarios when the user has made a selection in a visual that is cross filtering within the report page. So they are clicking on a line in the time series rather than making a selection within a slicer. Is this possible? Don't really want to turn cross filtering off as it's a great feature.

 

I currently have a clear filters button, too. But this solution would really be very useful.

 

 

  • Hi, Anonymous 

     

    Based on your description, I created data to reproduce your scenario.

    Table:

     

    You may create a measure as below.

     

    Iscrossfilteredbyclass = ISCROSSFILTERED('Table'[Class])

     

     

    Result:

     

     

    Best Regards

    Allan

     

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

     

7 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi amitchandak ,

       

      Thanks for the quick response. Turning interactions off is not what I want to do here. 

       

      Many thanks.

      • amitchandak's avatar
        amitchandak
        Super User

        Anonymous , can you explain with an example.

        I am hoping include, exclude on right-click  does not help you

  • v-alq-msft's avatar
    v-alq-msft
    Community Support

    Hi, Anonymous 

     

    Based on your description, I created data to reproduce your scenario.

    Table:

     

    You may create a measure as below.

     

    Iscrossfilteredbyclass = ISCROSSFILTERED('Table'[Class])

     

     

    Result:

     

     

    Best Regards

    Allan

     

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks v-alq-msft that looks like it may be what I need. So I can likely chain the ISCROSSFILTERED() command with '|' operator to cover all classes possible to select on the report page.