Dynmaic Filters

[krishnakumar_Ra]

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

[Greg_Deckler]

@krishnakumar_Ra Yeah, that's not going to work. You will need to unpivot those 3 columns.

[krishnakumar_Ra]

@Greg_Deckler  - Thank you. Can you please eloborate 

[Greg_Deckler]

@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.

[krishnakumar_Ra]

@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
***	****	****	****	***	***