How to change date filter view

[Zaky]

Hi Experts,

How can i change the date filter view from Visual 1 to Visual 2 by Year, Quarter, Month and Day?

Please help.

Thanks.

[Anonymous · Accepted solution]

@Zaky - It doesn't appear to be possible with the auto-hierarchy of a Date column. However, you could create a Date table, with a column for each attribute you're looking for. There are many scripts available to create a Date table in M (Power Query) or DAX.

Cheers!

Nathan