Forum Discussion

febc1992C's avatar
febc1992C
New Member
8 years ago

Show dates with no data on continuous date axis (Line graph) Power BI

Dear,

First of all, I apologize for my English, I write to you from South America, Chile. The following graph shows the units reprocessed daily by our factory. There is the possibility that on specific days there is no reprocessing (what is beneficial for us) however the formula takes those days as white values and not as 0, therefore, they are not graphed.

 

Ghrapic

 

 
 
My current formula does not consider white values as 0, for example, day 6 and day 11 should tend to 0 and then connect with the other days.

 

Unidades Mal Embaladas Reker = CALCULATE(SUM(IASC_RIPE[Unidades Suma]),IASC_RIPE[Embaladora]="PS-41")

 

Try adding a +0 to the formula or doing the following CALCULATE (If (ISBLANK (SUM (IASC_RIPE [Sum Units])), 0 ,, SUM (IASC_RIPE [Sum Units])), IASC_RIPE [Packer] = "PS- 41 "). The problem is that as I work with a hierarchy of relationships based on a table of dates, I plot days and months that do not yet exist with value 0. Attach example.

 

 

I have read the following: "Basically the problem is your orginal table simply lacks the necessary rows for the measures to work off. You can not add rows to existing phycical tables in DAX, but you can create new tables and plug the gaps in there."

 

However, I still do not have the skills in DAX to get this solution. I request your help to solve my problem.

3 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support

    Hi febc1992C,

     

    There photo you have uploaded can't be loaded, could you please upload again?

     

    Regards,

    Jimmy Tao

    • febc1992C's avatar
      febc1992C
      New Member

      Of course, no problem, here I upload the photographs again. Let me know if you have problems to visualize them.

       

      • febc1992C's avatar
        febc1992C
        New Member

        Hi, v-yuta-msft, here I upload the photographs again. Let me know if you have problems to visualize them.