Forum Discussion

AMBP73's avatar
AMBP73
Icon for Helper I rankHelper I
2 years ago
Solved

Card Visual to show 'Nil Selection'

Hello. I have a card visual that I would like to show current selection on a slicer. Could someone please advise on a dax measure to show "Nil Selected" on the card when no selection has been made o...
  • ChiragGarg2512's avatar
    ChiragGarg2512
    2 years ago

     

    The use of isfiltered will help here.

    measure = if(not(isfiltered(column on which the card will be filtered)), "Nil Selection", output column/measure )

ChiragGarg2512's avatar
ChiragGarg2512
Icon for Solution Sage rankSolution Sage
2 years ago

 

The use of isfiltered will help here.

measure = if(not(isfiltered(column on which the card will be filtered)), "Nil Selection", output column/measure )

  • AMBP73's avatar
    AMBP73
    Icon for Helper I rankHelper I
    2 years ago

    Hi, thanks for the solution. The 'Nil selected' is coming up when nothing is selected on the slicer, however when selecting a value I get an error? In the second part of the measure you provided it wouldn't allow me to put just the column so I created a measure for that column to input, maybe this is the issue? The measure I created for the second  

    Part is calculate(countrows).

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      change the last part to SelectedValue(column name used in filter) or [measure]