Friday, 3 October 2025

Power BI One Slicer to filter other slicers based on Items that has value only without BI Direction



Ref Video : 

https://www.youtube.com/watch?v=cyOquvfhzNM

https://www.youtube.com/watch?v=MeLaZFst02E


Step-1

    Create a measure like below.

Cascading=

   COALESCE(DISTINCTCOUNT('table'[ID]),0)

Step-2
    Put the created measure in this in this visual section of slicer pane as shown below


Step-3
    Now in the filter slicer only the relevant data related to the another selected slicer will only appear.


No comments:

Post a Comment