Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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.

@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!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

@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!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

@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!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.