Forum Discussion
Timeline Axis
- Use the forked arrow drilldown instead of the parallel arrow drill down?
Thanks! Could I ask for any advice on the other issues I have.
My chart looks like this.
1) How to display the last 12months (including current month)?
2) How to make naming shorter, e.g. Jan-20
For display data you can use relative date slicer
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range.
You can create the date table and have month year and month year sort there
Month Year = format([date],"MMM-YYYY") // This will not sort correctly
Month year Sort : format([date],"YYYYMM") // Mark this as the sort column of first one
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
