Single Value Card - None

LearningNinja
LearningNinja Member
in Cards, Dashboards, Stories

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 :)

Tagged:

Best Answer

  • david_cunningham
    david_cunningham Coach
    edited May 2024 Answer ✓

    @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…

    image.png

    Name selected…

    image.png

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

Answers

  • david_cunningham
    david_cunningham Coach
    edited May 2024 Answer ✓

    @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…

    image.png

    Name selected…

    image.png

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

Categories