Power BI Visualisation - Missing and Duplicate Lines - Sorce Data Correct - Relationship Issue?

[ccsnet]

Hi all, sorry this may not be the best post but I am still finding my feet with Power BI.

I have a few sources of data I pull on to create a single view.

As part of that build I have had to create relationships.

What I didnt know was adding the sources was changing what was in the view, I now have duplicate lines (not sure why as feilds look the same) and missing rows (I assume as all data was not found for a reason).

I had one additonal senario where there are 3 URL records which is associated with the 'project record' or row.

When added it removed all other data except these three where I simply just wanted to add the data of it matched and was available. 

Nb duplicates do not appear on a less complicated page. 

Is there a setting some where on a visulation that can tidy this up as its not the raw data or some thing I can look at on the relationships ?

Sorry I can not show examples directly due to the content.

Thanks

Terran

[ccsnet]

Hi all,

As thought I had a relationship problem. 

Still need to work out how to fix, I think it will be another table, then I can re implement it. 

Thanks

T

[Fowmy · Accepted solution]

@ccsnet 

Sorry, I couldn't understand what exactly is the issue that you are facing but if you are concerned about showing items regardless of data availability then, try turning on "Show item with no data"

[ccsnet]

Hi Fowmy,

Thanks for that - I think part one of my issue is resolved.

Intestingly I could only find it when creating a new visulation but I was able to do it so thanks.

For my second part - duplicates I have just grabbed this, sorry its only a small part.

The above is a single entry in data source 1 but it seems to be duplicating and blanking some feilds. All these shown here are actually from the same record in the same data source yet I am getting a duplication in lines. 

Terran

[Fowmy]

@ccsnet 

Sorry, it's a bit hard to figure it out without more details about your model.

[ccsnet]

OK... Thanks... I'm heading down the relationship route and or indexing but if I find the solution I will post here for others. Thanks for your help so far. 

T