Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I usually have a measure similar to this in order to then put it on the filter to hide a visual:
HideVisual = IF(SELECTEDVALUE('CALENDAR'[Period - Current]) IN {"Current"},1,0)
Hello @v-rzhou-msft ,
Can you please explain how we can achive this with the help of bookmark with slicer selection?
Hi @DanielCarvalho ,
As the Card dispalys only one value which has been aggregated always, we are not able to add a filter condition based on this aggregate value ("Average of Values").
When the specified fields under Visual level filters pane contain more than one value, then we can set filter condition like yellow highlighted section via Advanced filtering. Take a look at this article: How to use report filters.
I think you can just create a measure to show the result when you select the slicer.
HideVisual =
IF (
SELECTEDVALUE ( 'CALENDAR'[Period - Current] ) IN { "Current" },
[Card visual calculation like sum],
BLANK ()
)
Or you can create a bookmark to hide the visual.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
what would i put where you said card visual like sum??? and where would i apply this measure and how??'