Forum Discussion

seangovind's avatar
seangovind
Regular Visitor
6 years ago
Solved

Multiple Table Relationships

Hi all,   Happy Friday! I'm having a bit of difficluty with a bar graph visual I'm working on. I'm relatively new to Power BI and I believe my issue is stemming from my table relationships. What I ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi seangovind,

    I'd like to suggest you unpivot your error fields to convert them to attribute and value, then you can create a simple relationship mapping tables and do calculations across multiple error fields.

    Unpivot columns (Power Query) 

    Regards,

    Xiaoxin Sheng

parry2k's avatar
parry2k
Super User
6 years ago

seangovind it is surely the modelling issue, I would recommend to create sample pbix file non-sensitive data and share it. Also, make sure to share any data file you use in the report, it will help to model it correctly and solve your problem.

 

seangovind's avatar
seangovind
Regular Visitor
6 years ago

Good afternoon,

 

I actually am not too sure how to share the files on here, but I see a link to your email, so I will shoot you an email containing them.

 

Thank you so much!

Sean Govind