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

[febc1992C]

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.

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.

[v-yuta-msft]

Hi febc1992C,

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

Regards,

Jimmy Tao

[febc1992C]

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

[febc1992C]

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