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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
tommyschmid
Regular Visitor

First Last not working correctly

tommyschmid_0-1677254280588.png

When I am selecting the fields I want to use first last but it is not working correctly. What is more confusing it is pulling from the middle rows, any ideas why this is happening?

6 REPLIES 6
HughLa
Resolver IV
Resolver IV

Hi @tommyschmid 

 

Make sure you have a Numeric data type. Then you will be able to choose the Min and Max numbers.

 

I hope that solves the issue.

Hugh

lbendlin
Super User
Super User

what is your expected result?

i want 11, the latest entry in the list

check the filter context on the visual (via the funnel icon). There may be filters applied.

no filters applied

 

tommyschmid_0-1677608039881.png

tommyschmid_1-1677608047902.pngtommyschmid_2-1677608068978.png

see this is returning pass, because it is ordered alpha numeric, i just want the latest entry returned

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.