Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to 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.
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.
@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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |