Reply
Frequent Visitor
Posts: 2
Registered: ‎11-19-2018

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

[ Edited ]

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.

 

Print BI.JPG

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

Community Support Team
Posts: 1,951
Registered: ‎02-06-2018

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

Hi HercHP ,

 

You can add value "0" to these days.

 

Before add "0"

111.PNGCapture.PNG

 

After add "0"

22.PNG2.PNG 

 

Regards,

Jimmy Tao

Frequent Visitor
Posts: 2
Registered: ‎11-19-2018

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

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

Community Support Team
Posts: 1,951
Registered: ‎02-06-2018

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

Hi HercHP,

 

Click Modeling-> Data type-> decimal number.

Capture.PNG

Regards,

Jimmy Tao