Forum Discussion

Anonymous

Not applicable

5 years ago

Source data not matching up on Power BI

Hi All, i am relatively new to Power Bi (used it at a very basic level), but i am having a strange problem that i haven’t seen when i've used it before. i've already tried creating a new dashboard...

Icon for Super User rank

Super User

5 years ago

Hi Anonymous ,

Are bothe data sources in Power BI linked together somehow from which these dates are coming?

Also try brimging these in a table visual to check how it looks by removing any summarisation. Attach a screenshot here of a table visual.

Thanks,

Pragati

Anonymous

Not applicable

5 years ago

What do you mean by linked? The data is coming from these two tables:

When i try to create the visual tabel i get this error:

Thanks

Pragati11
Super User
5 years ago
Hi Anonymous ,

First rule of thumb in Power BI - If you want to use columns/measures from multiple tables in a single visual, then you need to create a relationship between them to get the right numbers on the visualisation.

By "linked" I mean, if both of your tables have a relationship or not. 🙂

Thanks,

Pragati
- Anonymous
  Not applicable
  5 years ago
  hi Pragati11 ,
  
  I see. This is the first time i am working with two different tables.
  
  The current relationship is 'Id'. I assume that this is the problem as why the data is incorrect?
  
  With being said what should the relationship be changed to is this isn’t the ideal one?
  
  Thank you
  - Pragati11
    Super User
    5 years ago
    Hi Anonymous ,
    
    Your relationship looks fine to me.
    
    Try moving ID column from one of the tables to your table visual along with other fields. It should not give you the earlier error.
    
    It will be nice if you can share your pbix file by removing any sensitive information from it. It's hard to suggest something at this moment.
    
    Thanks,
    
    Pragati