Forum Discussion
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...
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.
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.