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 ...
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.
Greg_Deckler Concept wise.. i see your point
here is whai will do
How will make sure if I choose Month.. i will have Month vlaues etc.. Any link please...
sorry to be a nag
| Name | City | DOB | Month | Year | Quarter | |
| John | Chicago | 18-05-2000 | May | 2000 | Q1-2000 | |
| *** | **** | **** | **** | *** | *** |