Forum Discussion
Card Visualization Latest Value
Dear All.
I have a card visualization that will show the status "Achieved" or "Not Achieved" depending on the Month filter selected by the user.
When the filter is selected, it displays the data correctly according to the month. But when there is no filter, it displays blank. How can I fix it so that if there is no filter selected, the card displays the value of the last month. (e.g. Sep 2020 for now)
Sample Table:
| Month | Value |
| Jan | Achieved |
| Feb | Not Achieved |
| Mar | Achieved |
| Apr | Achieved |
| May | Achieved |
| Jun | Achieved |
| Jul | Achieved |
| Aug | Not Achieved |
| Sep | Not Achieved |
Hi Riddlemirror ,
Sorry for replying late. You can put the value field in the card visual and set it as the last value so that it will show the latest month value by default.
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Riddlemirror , try with help from 2 measures
measure =
var _max = format(today(),"MMM")
return
calculate(Max(Table[value]) , Table[Month] =+max)final measure = if(isfiltered(Table[Month]),Max(Table[value]), [measure])
Hi.
Thank you for the reply.
It tells me there is a syntax error on this one:
😶
"The syntax for ')' is incorrect"
var _max = format(today(),"MMM")
return
calculate(Max(Table[value]) , Table[Month] =+max)
Hi Riddlemirror ,
Sorry for replying late. You can put the value field in the card visual and set it as the last value so that it will show the latest month value by default.
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
