Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
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).
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).
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |