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
Hello, im trying to find a way to only show latest data point in the data label of the chart below;
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
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.
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
109 | |
108 | |
108 | |
91 | |
61 |
User | Count |
---|---|
171 | |
138 | |
132 | |
102 | |
86 |