Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
26 | |
20 | |
14 | |
8 |
User | Count |
---|---|
76 | |
47 | |
46 | |
17 | |
16 |