Make appear 0 instead of Blank

[YRevolte]

Hello all,

Below a simplified view of my use case :

TIME.Date = FACTS.Creation date (active relationship)

TIME.Date = FACTS.Closure date (inactive relationship)

TIME is a date table, a reference table :

FACTS is my facts table where all the orders are registered.

I would like to make appear in the same chart the quantity created and closed during the time.

I’ve created these measures :

Created orders = SUM(FACTS[Quantity])

Closed orders = CALCULATE(SUM(FACTS[Quantity]),USERELATIONSHIP(FACTS[Closure date],'TIME'[Date]))

By these measures I have this result :

With this solution, there are BLANK instead of 0 for March (for example).

So, I’ve added “+0” to the measures but futures months are now valued…

Do you know a solution permit to make appear 0 for the past months and Blank for the future months ?

Thank in advance for your help... 🙂

[Ashish_Mathur]

Hi,

Just ensure that the Date table only goes uptil the last date that appears in the FACTS table.

[YRevolte]

Hi,

Thank you for your response.

But I would like to make appear the future months in the graph, not valued.

[Ashish_Mathur]

Hi,

Why do you want to show future months in the graph when there is no data for those future months.

[YRevolte]

Cause this is my need 😅

[ryan_mayu]

@YRevolte

here is a workaround for you.

pls see the attachment below

[YRevolte]

Hi,

Which version of PowerBi do you use ?

I have this result on your report :

0 is missing for March, April and May.

[ryan_mayu · Accepted solution]

@YRevolte 

updated the pbix file,pls see the attachment below.