Forum Discussion
Cumulative Total Line Graph Showing Legends by Year & Daily Granularity but X Axis Labelled by Month
HI there, Following previous help, I have a line graph as below which i have created to look like this: Axis: Date: Month Day Legend: Date: Year Values: cumulative DAX Me...
Can anyone provide help? I can add a calendar table if needs be.
Hi Anonymous ,
I created a sample pbix file(see attachment), please check whether that is what you want.
1. Create a calculated column as below to get YearMonth
YearMonth = YEAR ( 'DATA'[Date] ) & FORMAT ( 'DATA'[Date], "MMMM" )2. Create a line chart with below settings
Best Regards
Thanks for getting back to me Anonymous . Sorry I think I replied in the wrong place. This looks good, but not quite there - the lines need to be grouped not spread like that, like in my first graph. I would like the x axis to display month labels rather than day of the year labels, so granularity can be by day, and secondly for the current year I need the line to stop at the current date rather than continue to the end of the graph.
Can it be tweaked?