Forum Discussion
Solved
Date Hierachy
In my dataset I have a date column and I tried it's data type as Date or Date/Time but in both cases when I am using that column as Axis in Line chart, it is detecting "Date Hierachy" only as Year, n...
- At the moment, line charts don't support drill-down so they don't use the full date hierarchy capability. You can set it back to use just 'Date' by clicking the little dropdown arrow on it in the field well. We'll finish support for drill in line charts soon. Thanks!
Standard PBI hack seems to work...
Use a Line and Stacked Column Chart or visual with columns. That will allow you to filter to month or quarter.
Then change back to Line or Area Chart and it will maintain the selection.
Throught the forums I have noticed that they have removed some of these hack fixes, sometimes with supporting the feature sometimes not. Just so you know in case it breaks in a future release.
Hope that helps.