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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Show data only latest date in Card visualizations

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. 

 

DateIncSRChCtPrReqInct%Srs%AttNor%Count
30/03/2020000081326.50%1.67%0100%0
31/03/2020000051382.13%2.89%0100%0
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

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

 

allwynbazil_0-1662466074416.png

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.