Forum Discussion
Custom Date drop down slicer
Can you not simply add additional attributes to your existing Date Dimension table. Like attribute for Fiscal Year, Fiscal Quarter, etc. Then set up a Hierarchy in that Date Dimension of the Fiscal Year/Quarter/Month/Date.
Oh, and we really don't need to tag you in replies. You should get notifications of any replies regardless 🙂
Hi sid-agarwal
To achieve a wanted filtering functionality you need 2 things :
1. Fiscal calender , there are many guides of how to create it , for example :
https://www.youtube.com/watch?v=Lt_nNLQz0IE&t=7s2. To add a column to the created column which will check if the date is in current fiscal year and if yes it will giive a text "Current fiscal year" if no the original fiscar year.
The guide for creating the needed logic :
https://www.youtube.com/watch?v=um0dTXZhuekjust adopt it for your fiscal year calender
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi sid-agarwal
To achieve a wanted filtering functionality you need 2 things :
1. Fiscal calender , there are many guides of how to create it , for example :
https://www.youtube.com/watch?v=Lt_nNLQz0IE&t=7s
2. To add a column to the created column which will check if the date is in current fiscal year and if yes it will giive a text "Current fiscal year" if no the original fiscar year.
The guide for creating the needed logic :
https://www.youtube.com/watch?v=um0dTXZhuek
just adopt it for your fiscal year calender
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly