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/
Hello amitchandak
Yes when i convert it to whole numnber then i se the issue the slicer can get any number in between 20101(say january) to 202012(2020 dec) like 188477.Could you please explain on hte date solution then,maybe i need to get that in.
Thanks
Hello amitchandak ,
I guess it is solved.The Unpivot was the best part and then not getting it in the Axis was a small visualization thing i guess.I had hte date format in good one itself.I changed the X-aXIS Type to 'categorical' and it shows all the months and year.Thanks a lot.