A quick blog post on finding where the trend line is hiding in Power BI Desktop. Docs will state it is in the analytics pane for certain types of visualization. However, it doesn’t always show up:
(I really resisted the urge to post another “Dude, where is my car” image)
So why did the trend line disappear? Turns out the X-axis needs to be continuous, not categorical. You can change this in the properties of the X-axis:
However, still no trend line. This was caused by the effect that the attribute Year in my model had a string data type, and not integer (because why would I want to aggregate years?). Once I changed it to whole number in the query editor, my problem was solved:
(Still no percentile line though…)
This restriction of “continuous and numerical” means you can’t for example use a Year-Month column (e.g. 2017-06). I hope they solve this soon.