Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello--
I see there is a way to have multiple layouts of data models in the Relationship View tab.
Distinct from the 'All Tables' tab can you have: one page operate off one data model with different relationships, let's call it 'Tab A' and then another page operate off a separate data model with different relationships, calling this 'Tab B'?
Each of these models would be have distinct uses from one another for reporting purpose.
Appreciate any input thank--especially if I am looking at it from a wrong/harder way. Thank you.
@lma2356 wrote:Distinct from the 'All Tables' tab can you have: one page operate off one data model with different relationships, let's call it 'Tab A' and then another page operate off a separate data model with different relationships, calling this 'Tab B'?
No you can't have different relationships. The separate tabs just let you view a sub-set of the full model. It is purely a way of filtering the All Tables view, but under the covers it is still just a single data model.
To utilize different relationships you either need to setup inactive relationships and use the USERELATIONSHIP or CROSSFILTER functions within specific measures or create a separate file with another copy of your tables.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
7 | |
4 | |
2 | |
2 | |
1 |