Forum Discussion

Riddlemirror's avatar
Riddlemirror
Frequent Visitor
5 years ago
Solved

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...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    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's avatar
amitchandak
Super User
5 years ago

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's avatar
    Riddlemirror
    Frequent Visitor
    5 years ago

    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)