Forum Discussion
Dynmaic Filters
Period Filter Month Quarter Year |
i have a Period Filter..
IF Month Choosen
Next filer Values msut be
2024-01
2024-02
....
If Year chose
2021
2022
2023
...
Please note Month and Year values are seperate cols in the table see below
| Name | City | DOB | Month | Year | Quarter |
| John | Chicago | 18-05-2000 | 2000-05 | 2000 | Q2-2000 |
| Peter | India | 22-01-2024 | 2024-01 | 2024 | Q1-2024 |
4 Replies
krishnakumar_Ra Yeah, that's not going to work. You will need to unpivot those 3 columns.
Greg_Deckler - Thank you. Can you please eloborate
krishnakumar_Ra If you unpivot the last three columns you will end up with an Attribute column that has values of Year, Quarter, Month and a Value column with your year, quarter and month values. You can then have 2 slicers, one that uses Attribute and one that uses Values. When you select Year, your Values slicer will have only the Year values, etc. Or you could even do a hierarchy in a single slicer of Attribute and then Value. Let me know if that helps.
