Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Blank Text Card until something selected in a slicer

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 ...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
8 years ago

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

andreaabisaab's avatar
andreaabisaab
Regular Visitor
6 years ago

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 ! 🙂

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Same thing I did as well.  Looks cleaner.