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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
13 | |
10 | |
5 | |
3 | |
3 |