Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
VikramAdi
Helper II
Helper II

How to Filter Network spcific values in brand drop down

Hi, 

Having 3 tables data, need to add network,Brand,Date filters

VikramAdi_0-1694681951476.png

 

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 filter data as expected.

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

 

1 REPLY 1
lbendlin
Super User
Super User

PLease show your data model chart.  Don't join your fact tables, but instead control them all from the dimension tables. No bidirectional links if you can avoid them.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.