Forum Discussion
Missing data in visualizations
Hi,
I would suggest to create a dimension with the unique keys from both tables:
TableKeys = DISTINCT(union(VALUES(TableA[Key]),VALUES(TableB[Key])))
and create relationship the keys of your two tables. Then create this measure:
Measure = sum(TableA[ValueA])+sum(TableB[ValueB])
Use [Key] from the new table as category on your pie chart
Cheers,
Sturla
If this post helps, then please consider Accepting it as the solution. Kudos are nice too.
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.
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)?
