Have card display blank when slicer has no value selected

[LilMurph]

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

[eva_t1984]

Hallo, 

I am trying to have my card blank as well when the slicer has no values selected. 

I am using the following formular: 

IF(ISFILTERED('Product Groups'[Product Group]), FIRSTNONBLANK('Product Groups'[Product Group Name], 'Product Groups'[Product Group Name]), "")

I want to show the name of the Department within the Card and it works, but it does not work with row-level-security. I read on Microsoft that isfiltered and some oder function do not work with RLS. 

Is there a workaround? 

Thank you,

Eva

[eva_t1984]

I found a solution, I just added a _ALL Departments in my sharepoint list. And the card shows the first value on the list, when nothing is selected, which is the _ALL Deparment.

Thank you, Eva

[Kumail]

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 · Accepted solution]

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

[wajahathussain]

Hi, How did you do this. I created a measure and when i drag and drop it, it does not work on the card filter on the visual option. Any solution to it? Below is the screenshot.

[LilMurph]

This worked perfectly, thank you!