Forum Discussion

VikramAdi's avatar
VikramAdi
Helper II
2 years ago

How to fix slicer data ?

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