topic Card Visual to show 'Nil Selection' in DAX Commands and Tips

Card Visual to show 'Nil Selection'

AMBP73 — Wed, 20 Sep 2023 01:03:17 GMT

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 on the slicer?

Thanks in advance.

Re: Card Visual to show 'Nil Selection'

ChiragGarg2512 — Wed, 20 Sep 2023 09:42:16 GMT

The use of isfiltered will help here.

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

Re: Card Visual to show 'Nil Selection'

AMBP73 — Thu, 21 Sep 2023 00:09:57 GMT

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

Re: Card Visual to show 'Nil Selection'

Anonymous — Thu, 21 Sep 2023 09:46:58 GMT

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