Forum Discussion

Zaky's avatar
Zaky
Icon for Helper IV rankHelper IV
7 years ago
Solved

How to change date filter view

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's avatar
    Anonymous
    7 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    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