Forum Discussion

Everton's avatar
Everton
Helper I
7 years ago
Solved

Change Y axis interval

Hi,   I have a chart that shows appointments booked by time. I want to have the Axis show 15 minute intervals:     At 8:00 AM there is one appointment. The next appointment is at 9:00 AM. ...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Everton I think you mean y X-AXIS, change X-Axis type on format pane to Continuous and also click arrow button next 15min internval on Axis and select "Show items with no data"

parry2k's avatar
parry2k
Super User
7 years ago

Everton I think you mean y X-AXIS, change X-Axis type on format pane to Continuous and also click arrow button next 15min internval on Axis and select "Show items with no data"

Everton's avatar
Everton
Helper I
7 years ago

Thanks mate, Yes I did mean X Axis, sorry!

 

I tried what you said and it didn't change the graph. But when I change Type to "Categorical", it kind of gives the visual I need:

 

ContinuousCategoricalIt is close, I just need the line to continue, but dip down to zero rather than stop when there is no appointments. 

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Everton create a following measure and use that for value, change table and column name as per your model.

     

    Appointment Count = COUNT( Table[Appointment] ) + 0