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.
Hi All,
Please help me with how to display the latest values in Card visualizations for all columns. I have created a card visual for all columns individually. If I select the 31st Mar date, the value does not display selected date value in all visuals.
Date | Inc | SR | Ch | Ct | Pr | Req | Inct% | Srs% | Att | Nor% | Count |
30/03/2020 | 0 | 0 | 0 | 0 | 8 | 132 | 6.50% | 1.67% | 0 | 100% | 0 |
31/03/2020 | 0 | 0 | 0 | 0 | 5 | 138 | 2.13% | 2.89% | 0 | 100% | 0 |
Solved! Go to Solution.
@Anonymous
Create Measure like this
Measure1 =
var _max = maxx(Table,Table[Date])
return
calculate([Measure],filter(Table,Table[Date] =_max))
Or Create a flag in your table as column
Flag Column=
var _max = maxx(Table,Table[Date])
return
If(Table[Date] =_max,1,0)
Use this to filter the data
@Anonymous
Create Measure like this
Measure1 =
var _max = maxx(Table,Table[Date])
return
calculate([Measure],filter(Table,Table[Date] =_max))
Or Create a flag in your table as column
Flag Column=
var _max = maxx(Table,Table[Date])
return
If(Table[Date] =_max,1,0)
Use this to filter the data
Hello, in your expression what value are you using as measure?
calculate([Measure],filter(Table,Table[Date] =_max))
Hi @amitchandak,
What do you mean by measure in your formula below?
Measure1 =
var _max = maxx(Table,Table[Date])
return
calculate([Measure],filter(Table,Table[Date] =_max))
I am trying to pull the progress for the latest date in the card visual. However am not getting how to get it.
Please help.
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 |
---|---|
105 | |
96 | |
79 | |
67 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |