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 not have last 40 days' data.

[Day] is Date.

[Total Qty] is Number.

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!

7 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

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

     

    New Measure: =
[Total Qty] + 0
    • PBINoob_v3's avatar
      PBINoob_v3
      Frequent Visitor
      3 years ago

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

        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's avatar
    PBINoob_v3
    Frequent Visitor
    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!