cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ashamsuzzoha
Helper III
Helper III

How do I set the axis mininum to 0?

This is a just a bunch of zero values for this date range. Product manager doesn't want the axis to show negative values (no prediction should be negative). I've already set the  y-axis start value to 0 in the Format pane, but still getting the visual appearance below. Any way to fix this?

 

line chart.png

1 ACCEPTED SOLUTION
v-henryk-mstf
Community Support
Community Support

Hi @ashamsuzzoha ,

 

I reproduced your problem. I did a test: you need to set start and and for the y-axis. Then you can set the axis mininum to 0. 

vhenrykmstf_0-1626684221710.png

vhenrykmstf_1-1626684338513.png

 


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
v-henryk-mstf
Community Support
Community Support

Hi @ashamsuzzoha ,

 

I reproduced your problem. I did a test: you need to set start and and for the y-axis. Then you can set the axis mininum to 0. 

vhenrykmstf_0-1626684221710.png

vhenrykmstf_1-1626684338513.png

 


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

@v-henryk-mstf Problem is I have more data that is greater than 1. This problem is only for when I have filtered down to a subset of only 0s.

Greg_Deckler
Super User
Super User

@ashamsuzzoha Have you tried configuring the Filter pane to exclude negative values?


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

@Greg_Deckler Good idea. Did not work, unfortunately.

@ashamsuzzoha Hmm, trick seems to be to set your Start to 0 and your End to 1. See attached PBIX.

 


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

@Greg_Deckler So I do have more forecast data where it's the data is not all 0s, so setting the y-axis stop to 1 wouldn't really work unfortunately, but good idea!


How do you attach a pbix file to a message?

@ashamsuzzoha It's a thing Super Users can do. Here's a thought. Create a measure like:

 

Measure = 1

 

Add it to your Values field well. Set the line color to match your background.


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!