How to Show a card as Blank/empty if nothing is selected

[Anonymous]

Hi Everyone,

I am using a card that shows the average of a column. It is interactive with the table that has the column. When i click on a item on the table the number on the card changes which is great and what I want. But when i am not selecting any item on the table it just shows the average of the entire column. 

My question is, is there a way to have the card show nothing/empty if nothing is selected from the table and only show value once something is selected on the table.

Below is an example : 

Clumn Text	Column Value
A	1
B	2
C	3
D	4

Currently, card is showing the average of 2.5 (average of entire Column Value) when nothing is selected. I want the card to show Blank/emplty if nothing is sleceted from the Table ablove and provide a card value when Something is selected in the table, for example if I select A & B together it shoud give the average of 1.5 in the card.

Thanks 

[Anonymous]

Hi, 

You can hide the blank value using a Conditional Formatting rule on the Callout Value. The rule is 'if blank' then select the same color as the card or canvas background. 

I have created a video tutorial on how to create the conditional rule: https://youtu.be/Xsmbfpa4oCA

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

You can use ISFILTERED() or ISCROSSFILTERED() functions to determine if the table is selected.

[Anonymous]

Thanks a lot @Toerstad  and @v-eachen-msft , for my case ISFILTERED worked for me and getting exactly what I wanted.

Much appreciated

[v-eachen-msft]

Hi @Anonymous ,

Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.

[Toerstad]

Hi.

You could create a measure like this, and add it to a card-visual. Then you could select one ore more rows from a table- or matrix-visual and it will return the average of the values of the selected rows.

AverageValue = 
IF(
    ISCROSSFILTERED('Table'[Column Text]),
    AVERAGE('Table'[Column Value]),
    ""
)