How to display Blank in card when i have used date column if none of the filters are selected

[Naveen_SV]

I have an requriemnt in using the card visual i am displaying the date which as selelected earlist,

but my customer is looking for when there is no filters are selected it should disply (blank).

[Pragati11]

Hi @Naveen_SV ,

Just want some additional details on your query. What filter are you using to get this DATE value in card visual.

It will be nice to have a sample data here.

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[Naveen_SV]

@Pragati11  Thansk for your reply,

I am not able to attach the pbi file, but i have attachted snap shot,

consider there is two column country and dates, if i click on the country map then only date should disply in the card, else this should be display as blank.

[Pragati11]

Hi @Naveen_SV ,

You can create a measure as follows:

new Check 1 = var total = CALCULATE(COUNT(Table[Date]), ALL(Table[Date])) RETURN IF(HASONEVALUE(Table[Date]), SELECTEDVALUE(Table[Date]), BLANK())

Move this measure to your card visual.

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[Naveen_SV]

HI @Pragati11 

this was good for one value how about multi dates are there if i need to show first dates in that.

eX :

dATE               Country

22/02/2020     India

24/03/2020     India

[Pragati11]

Hi @Naveen_SV ,

You can modify your DAX as follows and try:

new Check 1 = var total = CALCULATE(COUNT(Table[Date]), ALL(Table[Country])) RETURN IF(HASONEVALUE(Table[Date]), SELECTEDVALUE(Table[Date]), IF(COUNT(Table[Date]) > 1 && COUNT(Table[Date]) < total, MAX(Table[Date]), BLANK()))

Also, try to understand the DAX expression above, so that you can modify it yourself.

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[Naveen_SV]

@Pragati11  thanks it worked 🙂