Card Visualization Latest Value

[Riddlemirror]

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

[v-yingjl · Accepted solution]

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 Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@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])

[Riddlemirror]

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)