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 two table named Gender and Subclass, the gender class has two observations namely "Male" and "Female". The Subclass table has 4 observations called "women's casual", "women's jeans", "men's casual" and "men's jeans".
I have made two slicers on my dashboard using the gender table and subclass table, I want the user to be able to select the gender from the gender slicer and the second slicer for subclass should only show the 2 values relevant for that gender, for example if the user selects "female" from the gender slicer the subclass slicer should only show "women's casual" and "women's jeans". Any suggestions would be highly appreciated.
Thanks.
Solved! Go to Solution.
Ok. Create a measure to use as a filter in the filter pane for each slicer with:
Filter slicers =
COUNTROWS ( RELATEDTABLE ( 'Sales' ) )
Add the measure to the filter pane for each slicer and set the value to greater or equal to 1
Proud to be a Super User!
Paul on Linkedin.
Ok. Create a measure to use as a filter in the filter pane for each slicer with:
Filter slicers =
COUNTROWS ( RELATEDTABLE ( 'Sales' ) )
Add the measure to the filter pane for each slicer and set the value to greater or equal to 1
Proud to be a Super User!
Paul on Linkedin.
Hey, thank you so much, that worked.
How is the model set up?
Proud to be a Super User!
Paul on Linkedin.
@PaulDBrown I have a main sales table with thousands of observations, and I have made two tables from this main sales table using the DISTINCT command for gender and the subclass table.
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |