How to fix slicer data ?

[VikramAdi]

Hi, 

Having 3 tables data, need to add network,Brand,Date slicers in report.

So for this scenario i have add 3 new tables,

A. date dimension table

B.Network dimension table

C.Brand table

3 tables joined with table 1,table 2,table 3.

Filters took from A,B,C.

Date filter working fine, but Network and brand filters not working hierarchy,

If i select one Network from network drop down, related brands not filtered, all brands are displying in brand drop down .

i want to see , if i filter data from network drop down,brand slicer also should display only network specific brands not all brands.

Need help here, can anyone suggest me how can i display data as expected.

can anyone suggest me how can i fix with current approch ? or any dax formula to resolve this issue

@amitchandak @Ritaf1983 @Ahmedx @Idrissshatila 

[Idrissshatila]

Hello @VikramAdi ,

Check if this video will help in your case https://youtu.be/nWgPynP9XDM?si=6cdpqmFptOFgBkLb

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡