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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
DanielCarvalho
Helper III
Helper III

Hide a card visual based on slicer selection

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)

or like this:
Hide Slicer = INT ( SELECTEDVALUE('CALENDAR'[Period - Current]) = "Current" )
When I try to this for a card visual, once I drop it on to filter its greyed out and it does not work... Does anyone know anyway around this? Basically what I want is when the current period is selected on my slicer, for it to show a certain card that does not show in all other periods(months)
DanielCarvalho_0-1689697038239.png

 



3 REPLIES 3
KeyurPatel14
Responsive Resident
Responsive Resident

Hello @v-rzhou-msft ,
Can you please explain how we can achive this with the help of bookmark with slicer selection?

v-rzhou-msft
Community Support
Community Support

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??'

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

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