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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
MelvinKhoo
Frequent Visitor

Help to find the max value

Hello, im trying to find a way to only show latest data point in the data label of the chart below;

 

 

MelvinKhoo_0-1681805236874.png

 

The idea i got from looking on the internet is by plotting my line chart to a clusetered column + line combo chart with the actual data labels in Y1 axis and the max value in Y2 axis.  I have problem creating the new measure to determine the max value. Since my original measure is cumulative, the max value should always be the latest data point. Below is a sample of my measure

MelvinKhoo_1-1681805504606.png

The problem is my new measure always return as empty. My hunch is SELECTEDVALUE(tbl_Calender[Date]) = _max could not find the right match. but i am not sure the cause of this
Help is much appreciated. Thanks.

1 REPLY 1
lbendlin
Super User
Super User

You mean you want to plot the values at the end of each month?

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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