Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Cascading Filters in Power BI

Hi all............

I want to Do Cascading Filters in Slicers.
i have total 9 filters. out of 9 filters 3 filters coming form one dim table. 2 filters from another dim table.another 2 filters from another dim table and another 2 filter are summarize columns.
Finally those 9 filters are coming from different table.So i wrote the dax like below. 
filter = INT(not isempty('WorkdayReward')|| not isempty('PeopleHRReward'))
WorkdayReward & PeopleHRReward these are the my fact tables. 

with the above dax Cascading is working, but if the filters are coming from same table it is working.

Please help me.....😊

Need Help

1 Reply

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    2 years ago

    Hi Anonymous ,

     

    For this you need to create a bidirectionality on your filters, so the calculation must include a CROSSFILTER expression that allows for you to get the values filter from one filter to the other.

     

    Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

    If the information is sensitive please share it trough private message.