How do I set the axis mininum to 0?

[ashamsuzzoha]

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?

[v-henryk-mstf · Accepted solution]

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. 

Best Regards,
Henry

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

[ashamsuzzoha]

@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]

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

[ashamsuzzoha]

@Greg_Deckler Good idea. Did not work, unfortunately.

[Greg_Deckler]

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

[ashamsuzzoha]

@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?

[Greg_Deckler]

@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.