Forum Discussion

Mesh's avatar
Mesh
Frequent Visitor
7 years ago
Solved

Display null date values in visualisation

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.

Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    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.

    Display-null-date-values-in-visualisation

     

     

    Best Regards,

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Mesh ,

     

    You can try with a measure like this:

     

    Sales =
VAR result = SUM(Table[Units])
RETURN
IF(result;result;0)
     
    Hope it helps
  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    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.

    Display-null-date-values-in-visualisation

     

     

    Best Regards,

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi Mesh ,

     

    Could you please mark the proper answers as solutions?

     

     

    Best Regards,