Forum Discussion
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
- amitchandakSuper User
Anonymous , Not sure I got it. But interactions van help you
https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
- AnonymousNot applicable
Hi amitchandak ,
Thanks for the quick response. Turning interactions off is not what I want to do here.
Many thanks.
- amitchandakSuper User
Anonymous , can you explain with an example.
I am hoping include, exclude on right-click does not help you
- v-alq-msftCommunity 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.
- AnonymousNot 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.