cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Eternally333
Regular Visitor

Custom Y axis (percentages) to start at zero though no data in some of the range

Hi

 

I did attempt to search on forum archives before posting as I'm sure this has been asked! But to be sure I have the correct answer.....

Found these previous threads

https://community.powerbi.com/t5/Desktop/Change-Y-axis-interval/m-p/356831

https://community.powerbi.com/t5/Desktop/Change-start-amp-end-points-amp-intervals-on-x-amp-y-axis/m...

Question is: can you custom Y axis to start at a custom start positon?

Issue is: line chart data value range starts say at 70% up to 100% but I want to show axis value starting from zero and the rest of the range though there's no data there. Is it possible please? Percentage_custom.JPG

1 ACCEPTED SOLUTION
parry2k
Super User
Super User

@Eternally333 on the format pane, you can give the minimum (Starting range) which will get you what you are looking for.

 

parry2k_0-1664207435366.png

 

 

Follow us on LinkedIn and YouTube.gif to our YouTube channel

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

 

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

3 REPLIES 3
searl
Frequent Visitor

Yes, it's just as easy as setting the y intercept to 0.

Go to your Visualisations panel, right click on the down arrow in your x axis field (which would be 'year' in your example) and then click on 'Show Items with no data';

searl_0-1664210393505.png

 

parry2k
Super User
Super User

@Eternally333 on the format pane, you can give the minimum (Starting range) which will get you what you are looking for.

 

parry2k_0-1664207435366.png

 

 

Follow us on LinkedIn and YouTube.gif to our YouTube channel

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

 

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Of course. I did try that and thought it failed as the lines became horizontal. Of course they would due to the scale. Thank you. 

 

 

 

 

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.