Forum Discussion

dobrygom's avatar
dobrygom
Frequent Visitor
4 years ago

Missing data in visualizations

There are 2 sample tables visible in the screenshot:  Table1 with T1Key and T1Value and Table2 with T1Key and T2Value columns. Left side/pie chart represents joining within the 'Model' on *Key colum...
Need Help
dobrygom's avatar
dobrygom
Frequent Visitor
4 years ago

I created the following table:   T1+T2 Keys = DISTINCT(union(VALUES('Table 1'[T1Key]),VALUES('Table 2'[T2Key])))  and joined it to Table 1 and Table 2 (chart below).

 
Because corresponding T2Values are null for T1+T2 Keys:  A and B, they are missing from the chart.
The desired effect is as visible in the MT (merged tables) chart.
 
I wonder if there is a way for PBI to recognize null values as blank values and not cut them out from the visuals.
 

v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

Hi dobrygom 

The reason is that in the returned table, the value of row A/B is null instead of "". you need to create a column

 

result

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

  • dobrygom's avatar
    dobrygom
    Frequent Visitor
    4 years ago

    desired outcome is shown below (note: columns E,F,G,H in the chart pie menu are (Blank) )

    the only way I found to achieve it (workaround) was by merging tables (full join)

    the join seemed to have replaced null values with blanks

     

    this is likely not the best workaround because if more than 2 tables are used, the joined "all tables in one" table would be massive and hard to manage

     

    what would be a proper/lighweight way to achieve this ? (basically not loosing key column values if related tables' values are null)?