Matrix visual : put a word "blank" in empty cell

[VoltesDev]

Hello guys,

In matrix visual, when we show two values coming from 2 different table but the relationship, in the value which don't have the relation usually we get blank space, can we somehow replace it with "extra" word, for example "<Blank>"

Fore example :

It is displaying two entity for the rows which is from 2 tables, there is some value which is not found->

It is ok to display the "not found" / unrelated, but rather than just an empty, I would want to replace it by something else

Thanks

[amitchandak]

@VoltesDev , if the empty value is there in the group /item_id column, You should replace that in Power query.

Power Query Replace Value: https://youtu.be/hkZhZbR7Kmk

But this coming because you have less values in dimension table then fact, then you need to fix data