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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

Show last label only on a line chart in power BI

Hi   having line graph in my power  bi visual . i want show the last lable in the power bi graph.

 

 

 

 

Measure for column Graph 

Actuals = CALCULATE(SUM('Master Data Base'[Value AC]),'Master Data Base'[Reduction buckets]=" Glidepath RF09")

 

Measuer  for line Graph 

Glidepath OB21 = CALCULATE(SUM('Master Data Base'[Value Month]),'Master Data Base'[Reduction buckets]=" Glidepath RF09")
 
Months for measure x axis 
Months = IF('Master Data Base'[Month]="Jan","Jan",IF('Master Data Base'[Month]="AC Jan","Jan",
IF('Master Data Base'[Month]="Feb","Feb",IF('Master Data Base'[Month]="AC Feb","Feb",
IF('Master Data Base'[Month]="AC Mar","Mar",IF('Master Data Base'[Month]="Mar","Mar",
IF('Master Data Base'[Month]="AC Apr","Apr",IF('Master Data Base'[Month]="Apr","Apr",
IF('Master Data Base'[Month]="AC May","May",IF('Master Data Base'[Month]="May","May",
IF('Master Data Base'[Month]="AC Jun","Jun",IF('Master Data Base'[Month]="Jun","Jun",
IF('Master Data Base'[Month]="AC Jul","Jul",IF('Master Data Base'[Month]="Jul","Jul",
IF('Master Data Base'[Month]="AC Aug","Aug",IF('Master Data Base'[Month]="Aug","Aug",
IF('Master Data Base'[Month]="AC Sep","Sep",IF('Master Data Base'[Month]="Sep","Sep",
IF('Master Data Base'[Month]="AC Oct","Oct",IF('Master Data Base'[Month]="Oct","Oct",
IF('Master Data Base'[Month]="AC Nov","Nov",IF('Master Data Base'[Month]="Nov","Nov",
IF('Master Data Base'[Month]="AC Dec","Dec",IF('Master Data Base'[Month]="Dec","Dec",
IF('Master Data Base'[Month]="Dec 2020","Dec 2020")))))))))))))))))))))))))

 

My current output:

THENNA_41_0-1637212038289.png

 

But Expecting Output Want to show last line lable in the line graph :

THENNA_41_1-1637212096824.png

 

 

any idea thanks in advance . 

 

 

 

2 REPLIES 2
Anonymous
Not applicable

@amitchandak  dear sir but  i using  last value this also low value ,should i keep user Maxx   fucntion  sir ?

amitchandak
Super User
Super User

@Anonymous , I have blog on same see if this can help

https://community.powerbi.com/t5/Community-Blog/Display-Label-Only-on-the-Last-Data-Point-of-the-Line-Visual-for/ba-p/1253464

 

Display Label Only on the Last Data Point of the Line Visual for a Trend  https://community.powerbi.com/t5/Community-Blog/Display-Label-Only-on-the-Last-Data-Point-of-the-Line-Visual-for/ba-p/1253464
Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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

Top Solution Authors