Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

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...

amitchandak
6 years ago
Anonymous , Try isfiltered

if(isfiltered(Table[zip code]),max(Table[Zip Code]),blank())

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

Icon for Super User rank

Super User

6 years ago

Anonymous , Try isfiltered

if(isfiltered(Table[zip code]),max(Table[Zip Code]),blank())

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

Anonymous
Not applicable
6 years ago
This works for getting the correct zip code but how would I apply this to text fields when trying to find the correct name on a record with that zip code.
- Pragati11
  Super User
  6 years ago
  Hi Anonymous ,
  
  First thing it will be nice if you can tag the person you are replying to in your response.
  Your last response is not clear to me regarding the text fields.
  
  Please explain your query in detail rather than us guessing.
  
  Thanks,
  Pragati
  - Anonymous
    Not applicable
    6 years ago
    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.