Show every day on the chart (same values equal to 0 or blank)

[Anonymous]

Show every day on the chart (same values equal to 0 or blank).

I have a chart that shows the capacity used each day. I need to show the days that I had no use.

I would like the days without data to be equal to "0%"

Could you help me ?

obs: I tried to add 0 to the metric, but it didn't work. =/

[Anonymous · Accepted solution]

Hi @Anonymous ,

Since there is no data model, I can only give you the following two methods for reference.

1. Make sure your date data type is date type.

2.If you want to display 0%, create a calendar table and create a relationship between two tables. Then create a measure and add 0 to your result.

Table 2 = CALENDAR(MIN('Table'[Date]),MAX('Table'[Date]))

Measure = SUM('Table'[Percentage])+0

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VahidDM]

Hi @Anonymous 

IF your model does not have all dates with value, You need to create a Calendar Table, connect that to the value table, and use that in the chart.

Creating Calendar Table in Power BI using DAX Functions

Share sample of your data table, or the Power BI file here to be able to work on it.

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos  !!