Line in the graph of lines and columns doesn't go down to 0

[Anonymous]

I have made a graph of lines and columns with a timeline in the X-axis and Number of Adjusts in the Y-axis, the table that feeds the columns have the numbers of adjusts through all days, on the other hand the table that feeds the line doesn't have values on sundays, i would like the line to go down to 0 on these days, but it shows the value of the next day.

The line should reach 0 on the days 02, 09 , 16, 23

[v-yuta-msft]

Hi HercHP ,

You can add value "0" to these days.

Before add "0"

After add "0"

 

Regards,

Jimmy Tao

[Anonymous]

The Y-axis values come from a counter that is calculated like this =1/CALCULATE(COUNTA(Z065223[Concatena D-F-O-OCR]); ALLEXCEPT(Z065223;Z065223[Concatena D-F-O-OCR])), i don't know how i can enter values to the table becaus the column [Concatena D-F-O-OCR] is a text column

[v-yuta-msft]

Hi HercHP,

Click Modeling-> Data type-> decimal number.

Regards,

Jimmy Tao