cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Reply
brianbonk
New Member

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

‎06-24-2015 10:19 PM

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

Message 1 of 4
6,547 Views
0
2 ACCEPTED SOLUTIONS
marcorusso
MVP

‎06-24-2015 10:54 PM
It is already here: go in Advanced Options and edit Cross filter direction in Advanced Options.

View solution in original post

Message 2 of 4
9,537 Views
0
marcorusso
MVP
In response to PolnerT

‎06-25-2015 01:38 AM
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

Message 4 of 4
9,521 Views
3 REPLIES 3
marcorusso
MVP

‎06-24-2015 10:54 PM
It is already here: go in Advanced Options and edit Cross filter direction in Advanced Options.
Message 2 of 4
9,538 Views
0
PolnerT
Power BI Team
Power BI Team
In response to marcorusso

‎06-25-2015 12:50 AM

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

Message 3 of 4
6,525 Views
0
marcorusso
MVP
In response to PolnerT

‎06-25-2015 01:38 AM
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.
Message 4 of 4
9,522 Views

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

View All