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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
brianbonk
New Member

Many to many relationships - same as the new tabular model?

Will the modelling of data include the new upgraded tabular many to many functionality as mentioned in the release notes of SQL Server 2016?

2 ACCEPTED SOLUTIONS

It is already here: go in Advanced Options and edit Cross filter direction in Advanced Options.

View solution in original post

In Excel 2016 you can apply the CROSSFILTER function to enable the bidirectional filter on a specific relationship (just as you change active relationship today with USERELATIONSHIP), but you will not able to enable bidirectional crossfilter in the data model like you do in Power BI Designer.

View solution in original post

3 REPLIES 3

It is already here: go in Advanced Options and edit Cross filter direction in Advanced Options.

Would Power Pivot get the same to be in feature parity with Power BI Designer?

In Excel 2016 you can apply the CROSSFILTER function to enable the bidirectional filter on a specific relationship (just as you change active relationship today with USERELATIONSHIP), but you will not able to enable bidirectional crossfilter in the data model like you do in Power BI Designer.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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