Display null date values in visualisation

[Mesh]

Hello, I'm trying to create a visualisation of dates and the visualisation is not showing null dates, only the dates with a recognised date in, which makes sense, but the null values are an important metric I want to track. Does anyone know how to get the visualisation to show null dates. I have made a temporary work around by changing null values to an impossible date, but I'm sure there must be a better way.

[v-jiascu-msft]

Hi @Mesh ,

Could you please mark the proper answers as solutions?

Best Regards,

[v-jiascu-msft · Accepted solution]

Hi @Mesh ,

Can you share a sample, please? Please mask the sensitive parts first.

The NULL dates show up in my two scenarios. Please refer to the snapshot below.

Best Regards,

[Anonymous]

Hi @Mesh ,

You can try with a measure like this:

Sales =
VAR result = SUM(Table[Units])
RETURN
IF(result;result;0)

Hope it helps