March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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:
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.
Solved! Go to Solution.
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.
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.
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.
@Anonymous , Not sure I got it. But interactions van help you
https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
Hi @amitchandak ,
Thanks for the quick response. Turning interactions off is not what I want to do here.
Many thanks.
@Anonymous , can you explain with an example.
I am hoping include, exclude on right-click does not help you
I have updated the original question to include an image of the report page.
You can see that at the top of the page there is a multicard that captures any slicer selection the user makes. I wondered if there was a similar solution for showing whether a user has made a selection within a visual that is cross filtering anywhere on the page. Like a warning card: "Warning, selections are filtering your data".
I'm unsure what include / exclude on right click refers to.
Thanks again,
Rich.
Just a high level idea
Try to add one card and group it with this visual. With the use of isfiltered or hasonevalue check if the date is filtered and display the message on the card
https://docs.microsoft.com/en-us/power-bi/desktop-grouping-visuals
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
If needed, Remove interaction of this card other than this trend visual
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
91 | |
90 | |
80 | |
49 |
User | Count |
---|---|
160 | |
145 | |
103 | |
72 | |
55 |