Forum Discussion
Solved
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...
Thanks Rico, the trend line option disappears when changed to categorical. I ended up not using the trend line.
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.
Thanks Rico, the trend line option disappears when changed to categorical. I ended up not using the trend line.