Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
trevrobwhite
Advocate I
Advocate I

Display data in a single table both sides of the arrow

I'm trying to display data both sides of the Power BI directional arrow and it's resulting in the can't determain relationships error, I'm not sure why.

 

There are more tables but in it's simplist form, I'm trying to display data from the wiz_containers table & data from the wiz_findings table.

 

Wiz_containers is related to the container_images and from there Power BI should be able to get the finding data but it doesn't, I tried enabling bi-directional filtering but that made no difference.

 

Including data from container_images, containers & findings also errors, it's only happy when I remove the container fields.

 

Any tips?  Thanks in advance

 

model_simplified.PNG

1 REPLY 1
lbendlin
Super User
Super User

take a step back and reevaluate your business scenario. Based on that create a data model with dimensions and facts.  Do not join fact tables directly.

 

Once you refactored the data model the visualization will work just fine.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.