Forum Discussion
Display Week start in Line Chart
Hi all,
I need to display the start of the week being a Monday date in the x-axis. I need to add in a trend line as well so I need the type to be continuous.
My DAX is 'DateTable'[Date] - WEEKDAY('DateTable'[Date],2) +1. The +1 just shifts the label 1 spot to the left, rather than it displaying the correct week start date.
If I use +3 it just shifts it further to the left.
What I want is for the x-axis to display 03 Jul, 10 Jul, 17 Jul, 24 Jul.
Thanks Rico, the trend line option disappears when changed to categorical. I ended up not using the trend line.
2 Replies
Hi Anon29 ,
As far as I know, the best for you should change the type of X axis to Categorical. I think Power BI support us to use trend line when your X axis type is Categorical.
For reference:
Use the Analytics pane in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Rico, the trend line option disappears when changed to categorical. I ended up not using the trend line.
