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 complexity reasons and UI cleanliness. However, before anything is typed in the cards will default to the first data point. I am wanting that to be displayed as blank to start and then when it is filter by zip code it will show the data. Any thoughts?
Anonymous , Try isfiltered
if(isfiltered(Table[zip code]),max(Table[Zip Code]),blank())
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
8 Replies
- amitchandak
Super User
Anonymous , Try isfiltered
if(isfiltered(Table[zip code]),max(Table[Zip Code]),blank())
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
- Pragati11
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
- Pragati11
Hi 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
