Forum Discussion
Help with chart and filters
Anonymous
First, unpivot the table
https://radacad.com/pivot-and-unpivot-with-power-bi
from month Create a date
Date = "1-" & table[Month] based on you format
Join with a date calendar table
There you can create month year and month year sort column
Month Year = format(date[date],"MMM-YYYY")
Month Year Sort = format(date[date],"YYYYMM")
Use those
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/
Hi Anonymous ,
You can try using a Slicer to select the year and month specific ranges.
In order to lose sight of the year when plot needs to be seen by month and vise versa, Drill down/Drill Up feature in line chart would automatically suffice the need using date hierarchy.
Hope this helps!
Thanks!