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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Jgeee
New Member

Y-axis scale of 0 to 1

Hi

 

I am wanting a Y-axis with a scale of 0 to 1, but PowerBi insists on including 0.5 on the Y-axis. The data being provided to the line chart will always be a 0 or 1, so how can I get it to show just 0 or 1?

 

I have set the Y-axis to have a minimum of 0 and a maximum of 1, but this doesn't work. Also if I tell it do not want any decimal places it just shows 0, 1, and 1 on the Y-axis.

 

Jgeee_0-1674486484263.png

Jgeee_1-1674486570582.png

Any help would be great.

1 ACCEPTED SOLUTION
LQuedas
Resolver II
Resolver II

Hey @Jgeee ,

 

to obtain what you want I used a workaround with Y-Axis Constant Lines, I 've hidden  the Y-axis and Added two Y-Axis Constant Lines, 

LQuedas_0-1674488421345.png

 

1) Disable the Y-Axis

LQuedas_1-1674488442382.png

 

2) Add a Y-Axis Constrant Line  with the value 0 

LQuedas_4-1674488630354.png

 

 

3) Add a Y-Axis Constrant Line  with the value 1

LQuedas_5-1674488685889.png

 

 

Hope this helps 😉

 

Cheers, LQ

View solution in original post

1 REPLY 1
LQuedas
Resolver II
Resolver II

Hey @Jgeee ,

 

to obtain what you want I used a workaround with Y-Axis Constant Lines, I 've hidden  the Y-axis and Added two Y-Axis Constant Lines, 

LQuedas_0-1674488421345.png

 

1) Disable the Y-Axis

LQuedas_1-1674488442382.png

 

2) Add a Y-Axis Constrant Line  with the value 0 

LQuedas_4-1674488630354.png

 

 

3) Add a Y-Axis Constrant Line  with the value 1

LQuedas_5-1674488685889.png

 

 

Hope this helps 😉

 

Cheers, LQ

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.