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"
in silcer1(Year) when i select 2022 then Slicer2(Status) dropdown should appear only 2 dimesnion as "40-Approved" &"50-Completed"
Please refer the screenshots attached
How can i achieve this by using any Dax measure/column? Any suggestions please
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
1 Reply
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