Single Value Card - None

LearningNinja

Hello Folks,

I am using Single Value card on my dashboard.

For example, there are 10 distinct names in the column selected in the Single Value card. In the dashboard, if I select any name on any visual, the selected name is displayed in the single value card. But, if I don't select a name, I want it to set to a default value like 'ALL' or 'None'.

This is the behaviour in Power BI. I am trying to replicate it here. How do I?

TIA :)

david_cunningham

@LearningNinja

You can do this in a beast mode.

case when COUNT(DISTINCT name)=1 then name else 'All' end

Then use that beast mode in your card. You can replace the word "All" with whatever your desired default value is.

For example - No Name selected…

Name selected…

david_cunningham

@LearningNinja

You can do this in a beast mode.

case when COUNT(DISTINCT name)=1 then name else 'All' end

Then use that beast mode in your card. You can replace the word "All" with whatever your desired default value is.

For example - No Name selected…

Name selected…