Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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).
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
@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.
Hi @Naveen_SV ,
You can create a measure as follows:
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
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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |