Forum Discussion
Solved
Time-Series Line chart multi-year grouping (Updated)
I'll preface this with I'm still learning Power BI so this may be one of those issues that you've seen a million times. I hope so because it's bugging me. The situation is that I have multi-year...
I recommend you invest in a proper calendar table.
Hi KierONeil ,
Please navigate to Format pane and change Type as "Category" in X-axis option.
Best Regards
You were right that I did have the x-axis set as Continuous and I changed it to Category and it looks like the image you show.
Unfortunately, It doesn't resolve the issue that I'm having.
What I expect to see is a line chart of daily sales from the start to the end like this example below. What I'm getting is the sum of sales on individual day numbers across the duration which isn't useful to me.
I looked at the x-axis on this chart and it's set to Continuous, if it matters. Other than that, it's the same as the chart I'm having issues with.