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 My query pulls in all of our sales area data. The purpose of the report pictured above is when a new customer is showing interest into our business a sales manager could type in the zip code to get all the necessary data shown to them instantly. I obviously do not what there to be data showing instantly so I want all the tiles to be blank. The formuals sent thus far would work for showing a card blank for zip codes but I am not sure how to transalte that to text fields as the formula did not work when replacing it with other columns.
