Date hierarchy in the filter

[lastnn30]

Hi

I have date field and when I insert in any visiualization, I would see date Hierachy (Day, Month, Year etc) and I can select only month for example. However; when I insert date filed in the filder (please see screenshot below). I would get that option anymore; instead I would get other options for example Advanced Filter, Top N etc. 

Is there a way to get Date Hierachy in the filter? Thank you very much.

  

[lastnn30]

Thank you very much.

[amitchandak · Accepted solution]

@lastnn30 , it always good to create a date table with column-like month, month year etc and use those

date =

Addcolumns(calendar(date(2020,01,01), date(2021,12,31) ), "Month no" , month([date])
, "Year", year([date])
, "Month Year", format([date],"mmm-yyyy")
, "Month year sort", year([date])*100 + month([date])
, "Month",FORMAT([Date],"mmmm")
, "Month sort", month([DAte])

)

Join it with date of your table