Forum Discussion
Line chart month end not start
Hi,
I have some 3 series of data plotted over Years/Months/Days in a line chart. However, when at the high level (which has the month names on the x-axis) the values called out on the graph are those at the month start - how do I change these to show the month-end values?
4 Replies
Hi tobiasmcbride ,
Are the values on the chart a measure or the values come directly from columns on your data table? If the values are from the data what is the aggregation you are using sum, max, min?
tobiasmcbride , not very clear
See if closingbalancemonth can help
https://docs.microsoft.com/en-us/dax/closingbalancemonth-function-dax
refer
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.tobiasmcbride
Can you provide a screen shot of the chart? Not sure what do you mean by month start, is that showing 1st of each but you want last day of each month?Regards
Paul Zheng _ Community Support Team
