Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 "1.Processed"
in silcer1(Year) when i select 2022 then Slicer2(Status) dropdown should appear only 2 dimesnion as "1.Processed" &"2.Forwarded"
How can i achieve this by using any Dax measure/column? Any suggestions please
Hi @Anonymous
You can place the measure in the filter pane of the slicer. Select "Is not blank" then apply the filter.
No Based on Selection in the slicer the values in the Slicer 2 should filter out dynamically
i thinki need to create a measure to achieve this by using selectedvalue dac function?
what is the DAX measure? any help
@Anonymous
The first slicer filters the measure and the measure filters the 2nd slicer
what is the dynamic DAX measure for this ?
@Anonymous
Good question. In irder to answer that I need information about your data model and relationships.
User | Count |
---|---|
53 | |
28 | |
19 | |
18 | |
14 |
User | Count |
---|---|
92 | |
86 | |
39 | |
23 | |
22 |