Forum Discussion

sridevi's avatar
sridevi
Icon for Helper I rankHelper I
9 years ago

Hide the data values or show blanks from Card visuals while not filtering data from slicer

Hi,   I need some help from you all. I need to hide my data from Card Visual chart in Power BI at initially in dashboard. I used some slicers for filters in my report. I want to show my card visual...
Need Help
yousuf's avatar
yousuf
Frequent Visitor
9 years ago

Hi sridevi,

 

Use this instead of BLANK function for anything you want to display.

 

Measure = IF( AND(HASONEVALUE('tableNAME'[slicerCOLUMN]),HASONEVALUE('tableNAME'[slicerCOLUMN])), SUM('tableNAME'[numerofunitsCOLUMN]), "Select Account" )

 

 

Hope this answers your question.

 

Thanks,

 

Yousuf