The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 |
---|---|
65 | |
62 | |
60 | |
53 | |
28 |
User | Count |
---|---|
181 | |
82 | |
67 | |
48 | |
44 |