Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
By default, the filter for the card visual is set to "last day", but if I select a day earlier or any other date earlier than the actual day, it shows "blank". How can I set the conditions so if its in a "free state" the visual shows "today", but if I choose a different date, it reflects it?
Appreciated.
Solved! Go to Solution.
HI @Lilya,
You can try to use the following measure formula if it meets your requirement.
Measure =
IF (
ISFILTERED ( Table[Date] ) = FALSE ()
|| SELECTEDVALUE ( Table[Date] ) = TODAY (),
TODAY ()
)
Regards,
Xiaoxin Sheng
HI @Lilya,
You can try to use the following measure formula if it meets your requirement.
Measure =
IF (
ISFILTERED ( Table[Date] ) = FALSE ()
|| SELECTEDVALUE ( Table[Date] ) = TODAY (),
TODAY ()
)
Regards,
Xiaoxin Sheng
@Lilya , try isfiltered https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
a measure like
if(isfiltered(Date[Date]), selectedvalue(Date[date]), today())
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |