Forum Discussion

brianbonk's avatar
brianbonk
New Member
11 years ago
Solved

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?

  • marcorusso's avatar
    marcorusso
    11 years ago
    It is already here: go in Advanced Options and edit Cross filter direction in Advanced Options.
  • marcorusso's avatar
    marcorusso
    11 years ago
    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.

3 Replies

  • marcorusso's avatar
    marcorusso
    Icon for Most Valuable Professional rankMost Valuable Professional
    11 years ago
    It is already here: go in Advanced Options and edit Cross filter direction in Advanced Options.
    • PolnerT's avatar
      PolnerT
      Icon for Power BI Team rankPower BI Team
      11 years ago

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

      • marcorusso's avatar
        marcorusso
        Icon for Most Valuable Professional rankMost Valuable Professional
        11 years ago
        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.