Display Week start in Line Chart

[Anon29]

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.

[Anonymous]

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 Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anon29 · Accepted solution]

Thanks Rico, the trend line option disappears when changed to categorical. I ended up not using the trend line.