Forum Discussion
Zaky
Helper IV
7 years agoHow 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.
- Anonymous7 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
- AnonymousNot 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