How to avoid Blank

[PBINoob_v3]

After filtering the data, both Day and Total Qty are blank.There is no data of last 40 days, so the dashboard is Blank. How to display 0 on the dashboard?

[Day] and [Total Qty] does not have last 40 days' data.

[Day] is Date.

[Total Qty] is Number.

[PBINoob_v3 · Accepted solution]

Hi, @DOLEARY85 @Jihwan_Kim 

I solved problem.

Of course  need to create a measure for [Total Qty], but still to make a little change on [Date].

I created a table that data is from Today to Last 40 days.

And I related the [Date] and [Day]:

Finaly, it displayed ZERO.

Thanks for your help!

[Jihwan_Kim]

Hi, 
Plrease try creating a new measure that looks something like below.

New Measure: =
[Total Qty] + 0

[PBINoob_v3]

Hi,

This is my measure:

total_line2 =

var _sales = SUM('ProdManual Line_Line2'[Total Qty])

return

IF(ISBLANK(_sales),0,_sales)

It doesn't work. Maybe it is [Day] 's problem

[DOLEARY85]

Hi,

try this:

total_line2 =

var _sales = SUM('ProdManual Line_Line2'[Total Qty])

return

COALESCE(_sales,0)

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[PBINoob_v3]

It is still Blank. 

[Day] and [Total Qty] are blank in the table, because there are no data of last 40 days.

Maybe i should create a measure for [Day]?

[DOLEARY85]

You could try that,

Maybe try the COALESCE on the Var before:

total_line2 =

var _sales = COALESCE(SUM('ProdManual Line_Line2'[Total Qty]),0)

return

COALESCE(_sales,0)

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[PBINoob_v3]

Hi, @DOLEARY85 

I just tried the COALESCE on the Var before, but it doesn't work.

I think maybe it is [Day]'s problem.May I ask you how to create a measure for Date.

Thank you!