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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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