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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
lherbert501
Helper V
Helper V

Inactive Relationshhip Just Slicer

Hi,

 

Could somebody please help me in the simple example that ive attached?

 

I need to make my relationship with stock and sales to the country active, but I have multiple measures in my actual sheet. I know that you can use userelationship on a measure by measure basis, but does this mean it has to be used on every measure on the page to work with the slicer?

 

Dummy Data.pbix

 

In the attached I need the country table to work and slice both tables, even though they already both use the item table in a bi directional way.

 

Thanks

 

Liam

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Change your data model slightly

 

lbendlin_0-1697411460028.png

 

View solution in original post

6 REPLIES 6
lbendlin
Super User
Super User

Change your data model slightly

 

lbendlin_0-1697411460028.png

 

Hi @lbendlin ,

 

Thankyou for this. If I was to include a date table in the same way the country table operates, would this slot in exactly the same?

 

Thanks

 

Liam

Yes, the date table is a dimension that controls both fact tables.

@lbendlin 

It doesn't seem to like it as I have to link via bridge table. Its creating many to many as date dimension has multiple entries for a period.

Make sure your fact tables have date columns. Create fake ones if needed. For example if your fact only has monthly granularity create a date column for the beginning of the month.

Thankyou so much for your time with this @lbendlin . It really is appreciated

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.