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
Anonymous
Not applicable

Stop showing the card value when no slicer is selected ?

Hello Team,

Hope you all are well.

 

As you can see, in the images below I have taken a slicer and a column chat and a card. 

In the image 1 when one select any item in the slicer its show it's corrsponding data in column chat and card.

user_Kdbl21_0-1677239561554.png

In the image 2 when no item is selected in the slicer, then NO data is there in column chat and but i can see the data in card.

user_Kdbl21_1-1677239612146.png

so how to make the card also blank(clear) like the column chat ? 

 

Any help will be helpful.
Thanks in advance.

4 REPLIES 4
Anonymous
Not applicable

hello @johnt75 .

Hope you are well. Congrats on your super user journey.

 

isFiltered = INT(ISFILTERED(TableDem2[Cat])), I have used this dax and its working fine incase of column chat but for card it's not okay. I saw your measure. I think you are saying me to use the same dax. If you are telling me use different dax, then please help me in briefing the DAX in details.
 
Thankx in advance.

If your existing measure was a simple SUM('Table'[Column]) then you could change the definition to be

My Measure = IF( ISFILTERED('Table'[Cat]), SUM('Table'[Column]))
Anonymous
Not applicable

no it's not a sum, it's actually a sentence.

johnt75
Super User
Super User

You could change your measure to add IF( ISFILTERED( 'Table'[cat]) ) around the existing definition

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.