Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |