Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Riddlemirror
Frequent Visitor

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:

 

MonthValue
JanAchieved
FebNot Achieved
MarAchieved
Apr Achieved
May Achieved
Jun Achieved
Jul Achieved
AugNot Achieved
SepNot Achieved
1 ACCEPTED SOLUTION
v-yingjl
Community Support
Community Support

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.

last value.png

 

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.

View solution in original post

3 REPLIES 3
v-yingjl
Community Support
Community Support

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.

last value.png

 

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
Super User
Super User

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.