Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Axis Start Stop Error

I have a PBI with a line and clustered column chart where all values are negative (only costs are shown). I want to fix the start and stop of the Y-axis , because when I select options in the slicers I want the bar sizes to bring meaning.

I keep getting an error "The number is too high" or the "The number is too low", when I try to fix both start and stop - the error message depends on which field is set first - so currently I can only set one the fields with static values.

It's really strange because I have another chart which is basically the same, however all values are positive (only revenue shown): the start is set to 0 and stop to 90, with no problems at all.

 

Is there a way to fix this?

  • Anonymous's avatar
    Anonymous
    6 years ago

    I figured it out myself: since all values are negative, the start must be the lowest value and the stop must be the highest value (zero in my case).

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    I figured it out myself: since all values are negative, the start must be the lowest value and the stop must be the highest value (zero in my case).