Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
AMBP73
Helper I
Helper I

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

Thanks in advance.

1 ACCEPTED SOLUTION
ChiragGarg2512
Super User
Super User

ChiragGarg2512_0-1695202750034.png

 

The use of isfiltered will help here.

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

View solution in original post

3 REPLIES 3
ChiragGarg2512
Super User
Super User

ChiragGarg2512_0-1695202750034.png

 

The use of isfiltered will help here.

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

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

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Kudoed Authors