Forum Discussion
Trend Lines
Thanks for the reply...so you say that on the chart itself the category being a date type but displaying a month name which it does automatically it can't trend across that? Seems like you are saying that once I drilldown from Years I have to have the months displayed as 1,2,3,4,etc... makes no sense because if you then drilldown to days which are 1 - 30 it stil doesn't work.
I am not using a lookup that has month names in it it is just a Date column that automatically gets the date hierarchy see below how it disappears:
Initial chart trend okthis is the axis data a date type which converts to thisyou can see the trend line is availablethis is the view once you drilldown to quarters no trendlineno trend option at quarter leveleven when down to day level still no trend line
phillip786 trend lines won't work below a text level in a hierarchy either. It will only work at the top level if the top level is a numeric value, and if any level below that is not a numeric value it will stop working for that level and all below it. It's pretty much all or nothing. You can't use the default hierarchy for dates; I suppose you'd have to construct your own fully numeric hierarchy. Hopefully this will be remedied in the future but for now that's how it is.
Anonymous Thanks for the info, I got it to work by creating a new measure that was just the =Month() of the date column and used that in my trend by month chart. I hope they get this fixed or be able to have a Value/Label pair so we can have Month names while still keeping the trend line.
phillip786 as far as I can tell the current trend lines are just the initial implementation, not the complete support they eventually plan. Seems to be the pattern with Power BI development: they release a feature as soon as the minimum usable version of it is ready rather than waiting until they have a more finished product. It's good because new features show up relatively quickly and we can provide feedback earlier in the development process, but bad because now I have a program full of half-features that I want but can't use yet.