How to display 0 instead of blank in matrix if a record does not exist

[Prima_]

Hi,

 How to display '0' for the column values instead of blank if there are no records for an Order on a particular date? 

Here's my test data

Here's my Power Bi matrix visual:

Thank you.

[Prima_]

Thank you.

[Ashish_Mathur]

Hi,

Drag this measure to the matrix visual

Measure = coalesce(sum(Data[Value]),0)

Hope this helps.

[Fowmy]

@Prima_ 

As there is no record available in your table for those missing combinations, it is not possible to format or assign value to those cells in the matrix.

[Prima_ · Accepted solution]

oh ok. Thank you.