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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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?