cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LilMurph
Regular Visitor

Have card display blank when slicer has no value selected

Hi all,

I have a data set imported from an SQL Database. One of the columns provides Resource ID's (employee names). One of the sheets on my report is a dashboard which shows employee stats. I have a slicer set up for Resource ID so that when no-one is selected it shows the total stats, and when I select a name it shows me just their stats. 

The problem I am having is that I have placed a card at the top of the page poplated with resource ID so that when I select someone is shows their name, but when no-one is selected, it still shows the name at the top of the list. I want it so that when no-one is selected by the slicer it is just blank or says something like total. I can't manipulate the source data to add a name such as total and I can't figure out how to do it. 

Any help/advice would be greatly appricited.

Cheers
Murph

1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

@LilMurph Write a measure for the display name and put that in the card.

Display Name = SELECTEDVALUE ( 'Table'[Name Column],"" )

That will show an empty string if there is not a single selected value.

View solution in original post

3 REPLIES 3
Kumail
Continued Contributor
Continued Contributor

Hello @LilMurph 

 

Instead of just column name in the slicer for employee, you can use following

Calculate ( if( is blank(), "Total", [Column Name])

 

This will solve your issue.

 

Regards

Kumail Raza

If this answers your query, mark it as solution.

Kudos are appreciated.

 

 

 

 

 

jdbuchanan71
Super User
Super User

@LilMurph Write a measure for the display name and put that in the card.

Display Name = SELECTEDVALUE ( 'Table'[Name Column],"" )

That will show an empty string if there is not a single selected value.

View solution in original post

This worked perfectly, thank you!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.