Blank Text Card until something selected in a slicer

[Anonymous]

Hi

I have a report with multiple slicers and I am using a text card to show the name of the account selected. When the user doesnt select anything it is showing the first account name. How can I show it the way that the text card will stay blank untill the user selects one account. 

Thank you 

I found similar topics but none of it worked. 

Thank you 

[sraj]

I need to do something similar but just for one of my slicers, Its a GL account slicer and i need to show the name the GL ACCOUNT only when the account is selected.  Can someone please advise?

[v-frfei-msft · Accepted solution]

Hi @Anonymous,

Here I made a sample to meet your requirement. We can create a measure like this to get the the result as we excepted.

Measure = IF(ISFILTERED(Table1[name]) || ISFILTERED(Table1[Plant]) || ISFILTERED(Table1[VAS type])||ISFILTERED(Table1[date]),FIRSTNONBLANK(Table1[name],Table1[name]),BLANK())

For more details, please check the pbix as attached.

https://www.dropbox.com/s/axa0yq95rvm8itk/Blank%20Text%20Card%20until%20something%20selected%20in%20a%20slicer.pbix?dl=0

Regards,

Frank

[mohiniverma2704]

Hi , This worked for me but at thi point it show blank . In case we want to display "Text" in Card instead of black when selected all then what will be the query?

[Arunsawas]

I try to used the same formula but the card appeared only Blank, it was not change while I selected other item? Do I have to put all the colum in the table or just the column that I used to make the whole project (including another tab)

[jimmy7377]

Hello all

I am trying to do somthing simlar but with a Card and the card normally hold dates so this is what I have 

ProjectStartDateMeasure = if(HASONEVALUE(Table[Column), FIRSTDATE(Table[Column]),"Select Project")

When nothing is selected I get Select Project but when i select a date i get 

This has now taken to many hours, wall, head. you get the picture. Please someone put me out of misory pretty please.

[yazenbarakat123]

Try something like this ! 

    FORMAT(SELECTEDVALUE ( Dates[Date] ),"dd/mm/yyyy")

it worked for me ! if so please accpet this as a valid solution as it would be my first 🙂 

@jimmy7377 

[yazenbarakat123]

Did you ever Find the solution to this Issue? Running into something very similar 

[andreaabisaab]

hi @v-frfei-msft 

this has worked perfectly for me, thanks! 

I have made a little change in your expression, because i didn't want " (Blank) " to appear on my card, so here's the expression I used: 

Measure = IF(ISFILTERED(Table1[name]) || ISFILTERED(Table1[Plant]) || ISFILTERED(Table1[VAS type])||ISFILTERED(Table1[date]),FIRSTNONBLANK(Table1[name],Table1[name]),"")

Thanks ! 🙂

[HVACGUY8989]

Same thing I did as well.  Looks cleaner. 

[v-frfei-msft]

Hi @Anonymous,

Does that make sense? If so, kindly mark my answer as a solution to close the case.

Regards,
Frank

[datafitters]

Create a measure that shows the FIRST(account), and only when 1 account is selected.

something like this (pseudocode, not tested):

Name of account=IF(HASONEVALUE(account);FIRST(account);blank() )