Forum Discussion

sridevi's avatar
sridevi
Helper 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
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello! I am currently using almost the same exact DAX code that was proposed in the solution in a tooltip right now seen here...

 

"Filter_Measure = if(and(hasonevalue(Building_Reports2[Year]),HASONEVALUE(Building_Reports2[Year])),sum(Building_Reports2[EUI]),0)"

 

I was wondering if there was any way to instead of using "blank" or "0" if I would be able to insert a brief message (i.e. "Please filter by ...")? Currently whenever I enter a string in this section the visual is popping up as blank when unfiltered. But when I use a zero the zero will pop up. Any tips, comments or suggestions are welcomed, thanks! 

 

Austin I 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Looks like I answered my own question. This method seems to work just fine with a card visual but the gauge visual that I was attempting to use did not allow it to work