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 ...
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.
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 nagName City DOB Month Year Quarter John Chicago 18-05-2000 May 2000 Q1-2000 *** **** **** **** *** ***