Forum Discussion
Dynamic Default value on slicer based on selected value
I have two slicers, Year and Quarter. The Year slicer has 'Current Year' and 'Last Year'. The quarter slicer has Year_Quarter. I want the quarter slicer to dynamically change based on the year ...
Thanks for the file, unfortunately from the dummy file I am not able to identify what you are trying to achieve, I would suggest please share the pbix with dummy data but with your required visuals and structure.
If Previous Year is selected, the Year_Qtr_label should default to 'Previous Year Current Quarter.
If Current Year is selected, 'Current Quarter should be selected by default.
Note: The Quarter Data table should not have any impact on Current Year/Previous Year toggle. It should only toggle on Year_Qtr Label.