Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Visualizing Data with Null Records AKA Left Join

I notice when you have a table and you bring in a field, say "customer". It results in a list of rows. Lets say 25 rows for this example. Next you want to bring in another field. For this example let...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

darentengmfs 

 

How do you do it, if you only have one table that holds the data.

 

I start with 36 rows and end with 24 after I bring in the measure.  I can't really modify the join because the data is held in the same table.  I am connecting to Dynamics 365 (Online).

 

darentengmfs's avatar
darentengmfs
Icon for Post Prodigy rankPost Prodigy
5 years ago

Anonymous 

 

How is your table pulled? Can you share your query?

 

Also the screenshot you sent is blurred, I can't see anything.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    darentengmfs 

     

    I can't share the query but this is my connection.

     

     

    I guess one solution would be to replace the "null" value to 0, but I don't want to have to do that for every column in the data source.

    Is there a setting to include nulls in the power view?

    • darentengmfs's avatar
      darentengmfs
      Icon for Post Prodigy rankPost Prodigy
      5 years ago

      Anonymous 

       

      If you want to replace null values to 0, you can select all columns, under Transform tab, click Replace Values. This should replace every column with null values.

       

      However, I believe when you import the data into Power BI, as long as the row has a cell with non-blank/non-null value, it will show up in your dataset.