Forum Discussion
Dynamic Slicer selection - DAX Measure/Column
-Hi, i have a requirement, 2 columns, Year column and Status column in silcer1(Year) when i select 2021 then Slicer2(Status) dropdown values should appear only 1 dimesnion as "40-Approved" i...
Anonymous You could create a parameters table for use in your slicers:
Year Status 2021 40 - Approved by BU 2022 40 - Approved by BU 2022 50 - Completed
Greg_Deckler
Community Champion
Community ChampionAnonymous You could create a parameters table for use in your slicers:
| Year | Status |
| 2021 | 40 - Approved by BU |
| 2022 | 40 - Approved by BU |
| 2022 | 50 - Completed |