- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Connection of Tables in PowerBI
Hi,
I have three tables in PowerBI, you can see the connection between the tables below:
When I try to add data from all three tables into a visual, my visual breaks (screenshot below):
Do you know how I can fix this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi I cannot upload a file but I can upload screen shots of the table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

I want to display the "ID" field from the Reports table, "title" from Results table and "reason" from Reviews table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hey @MissBI_21
Can you please share the sample data of all three tables after removing sensitive information, so that I can try on my system and provide accurate solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hey @MissBI_21
Please provide more information about what exactly you want to plot on that visuals,
the possible problem can be because of ambiguity in records from two tables having multiple records, the solution to this is to plot visuals using data from the fact table(having duplicate values) in your case "results" or "reviewers" and plot slicers using dimension table(having unique values) in your case table "reports".
If it helps you, please mark my solution as accepted so that others can find it quickly when facing a similar issue. Thank you!

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-07-2024 01:32 AM | |||
07-25-2024 08:07 AM | |||
07-08-2024 08:44 AM | |||
05-14-2024 04:59 AM | |||
06-11-2024 03:26 PM |
User | Count |
---|---|
140 | |
110 | |
81 | |
60 | |
46 |