(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.
The Power BI Enhanced Report Format (PBIR) will soon become the default, and that's a…
Quite a long title for a short blog post :)While deploying a DACPAC (from a…
Yes, you're reading that right, we're going to download a report that cannot be downloaded.…
You can find all the session materials for the presentation "Indexing for Dummies" that was…
The slidedeck and the SQL scripts for the session Indexing for Dummies can be found…
You can find the slides of my session on the €100 DWH in Azure on…
View Comments
can you show the trend line year and month wise
I'm not sure what you mean. I think you can have a trend line when you have a date hierarchy and you drill down to months? I'd have to test it out.
Didn't get your point at all. Can you tell me in very simple terms which line is the trend line? The green or the black dotted one?
The black dotted one.
"Once I changed it to whole number in the query editor, my problem was solved:" Can you give a screenshot of how to do this? I only see the options to change the entire field's data type, not just the year attribute. Thanks!
What do you mean with the "entire field"?
Do you have a auto-created data hierarchy?
One other issue I found is that the trend lines goes when there is no data on the chart. Let's say I have a chart with months the my data starts in March and continues to the rest of the year. The trend line starts at January even though there is no data for January and February. I do not want it and want the line to start at March. Do not see any setting for that.