Trend Line Disappears with Year & Week

Hi mkohler281 

Here are some steps you can try:

Check Data Model: Ensure your data model includes a 'Date' table with 'Year' and 'Week Number' columns properly calculated and marked as a date table with appropriate relationships.

Review Sort Order: It's important to have a unique sort order for your 'Week Number' column. Create a column that combines 'Year' and 'Week Number' to provide a unique sort order.

Adjust Line Chart Axis: On your line chart, make sure you're using the 'Week Number' field from the 'Date' table as the axis and that it is sorted by 'YearWeekSort'.

Verify Trend Line Settings: Ensure that the trend line is correctly configured. You can do this by clicking on the analytics pane within your line chart visual and making sure the trend line is added and set up correctly.

Ensure Data Completeness: Verify that your data does not have any gaps for the 'Year' and 'Week Number' combinations, as missing data can cause the trend line to not display correctly.

Check Visual Interactions: If you have multiple visuals on your report page, make sure that the interactions between them are not filtering out data in a way that would remove the trend line.

Update Power BI: Ensure you are using the latest version of Power BI Desktop, as updates often include bug fixes that may resolve your issue.

Regards,

Nono Chen

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