Forum Discussion

ccsnet's avatar
ccsnet
Frequent Visitor
2 years ago
Solved

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

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 c...
  • Fowmy's avatar
    Fowmy
    2 years ago

    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"


     

Fowmy's avatar
Fowmy
Super User
2 years ago

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's avatar
ccsnet
Frequent Visitor
2 years ago

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's avatar
    Fowmy
    Super User
    2 years ago

    ccsnet 

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

    • ccsnet's avatar
      ccsnet
      Frequent Visitor
      2 years ago

      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