Forum Discussion

PBINoob_v3's avatar
PBINoob_v3
Frequent Visitor
3 years ago
Solved

How to avoid Blank

  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 n...
Need Help
  • PBINoob_v3's avatar
    PBINoob_v3
    3 years ago

     

    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!

PBINoob_v3's avatar
PBINoob_v3
Frequent Visitor
3 years ago

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's avatar
DOLEARY85
Resident Rockstar
3 years ago

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's avatar
    PBINoob_v3
    Frequent Visitor
    3 years ago

    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!