Forum Discussion
Make a Card Visual Start as blank
I am creating a lookup page report for our users. It will allow a user to type in a zip code and then show all of the correlating data points. I am using card visuals to display each data point for c...
Anonymous , Try isfiltered
if(isfiltered(Table[zip code]),max(Table[Zip Code]),blank())
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
Pragati11
Super User
Super UserHi Anonymous ,
Try something as below:
Measure = IF(ISFILTERED(Table1[Column1]),FIRSTNONBLANK(Table1[Column1], Table1[Column1])," ")
In the above measure, replace Table1[Column1] with your zipcode column. Then move this above measure to your card visual.
Thanks,
Pragati
I need to do this for all cards which are each different columns in the data set. I attempted to do this with the AR column and it made it blank but when I typed in a zip code it left it blank still.