Forum Discussion
Slicer Option
Hi, Please help to achieve below requirement for Slicer. We have requirement for Slicer. Suppose we select Project Name in Slicer by default other slicer is showing All. But we n...
If you want the slicers to show the values available based on a selection, you can use a measure to filter the slicers. Something along the lines of:
Filter slicers =
COUNTROWS ( RELATEDTABLE ( 'Fact Table' ) )
where 'Fact Table' is the table the slicers relate to.
Add this measure to the filter pane of each of the slicers and set the value to greater or equal to 1
Reference:
https://learn.microsoft.com/en-us/dax/relatedtable-function-dax
(Basically RELATEDTABLE reverses the direction of the relationship in a dimension to fact table)