top of page

Error bars tricks - Bar chart with rounded corners

Mara Pereira

If you’ve been following my posts, you probably know by now that one of the things that really annoys me in Power BI is not being able to build bar charts with rounded corners, unless you use a custom visual.


However, recently I found out about a trick to make this happen without needing to use custom visuals (special shout out to Federico Pastor who shared this trick with me!).


And what is the trick? The trick is using error bars! So instead of having the chart on the left, we will end up with the chart on the right, which looks pretty cool don’t you think?





Let’s get started!



Note 1: for this exercise, I’m using the sample Financials dataset from Power BI. You can easily get this sample data by clicking on “”Try a sample dataset” when you open Power BI Desktop (check image below).




Note 2: for this exercise, I’m using the new On Object feature in Power BI Desktop. To enable this feature go to:

File > Options and Settings > Options > Preview Features > On object interaction




1) To start this exercise, I built a line chart using the country column as the X-Axis and the Sales column as the Y-Axis:


(Yes, a line chart to build a bar chart, weird I know! But wait for it...)



2) Click on the "Add or remove visual elements" option in your line chart (there will be two squares with two options on the top left corner, it's the one with the little painter brush!). Then click on the "More options" button so you can see the Format tab for the chart:


3) In the Format pane, if you scroll down, you will see the Error Bars section. In the Options, Enable the error bars by changing the toggle to On:


4) Now we need to define the Upper bound and Lower bound for the error bars.


The upper bound will be the value you used as the Y-Axis, in this case, the Sales amount.


The lower bound will be zero, as we know there won't be negative sales for this dataset we should be ok (this trick works better if your values always have a zero baseline).


For the Lower bound, I just created a measure like the one below:

Lower Bound = 0


5) Now we just add our two values to the correspondent fields in the Error Bars section of the Format Pane.


By the way, if the Format Pane disapears, you just have to click here:


Let's add the Upper Bound value to our Error Bars:


And now the Lower Bound value:


So now you should have something that looks like this:


It doesn't really look like a bar chart does it? We will change that in the next few steps!



6) It's time to format our bars so they look more like a bar chart instead of... yea... whatever it looked like before!


Still in the Error Bars section of the Format pane, we are now going to max the width of the bar (put it as 10):


Now here is the trick to make the bar corners look rounded!

Change the marker shape to a circle, make sure the border color is the same as the bar color, and then change the marker size so it matches the width of the bar (a bit of trial and error might be needed here):


Can you see the rounded corners already? It looks awesome!!



7) That line is not doing much in our chart now... To remove it, go to the Lines section of the Format Pane, and then set the stroke of the line to zero:


8) Now it's just a matter of formatting the chart a little, things changing the chart title, removing the Axis titles. To do this, you just have to double click in the part of the chart you want to edit (e.g. double click on the title of the chart) and you should be able to easily change and format it:


You can easily remove the Axis titles by double clicking on them, and disabling them on the Format Pane:


Do the same for the Y-Axis.



This is my chart with the formatting changes applied to it:


Now I'm just adding some data labels to make my new fancy bar chart more insightful:




And here it is, our line chart transformed into a bar chart using error bars!


Note: The tooltips will show the error bar values, if you want to remove these from your chart, go to the formatting options of the Error Bars and disable the Tooltip:




I hope you found this post useful :)

7,276 views9 comments

Recent Posts

See All

9 Comments


jehip15590
5 hours ago

Top Home Remodeling Services for Your Dream Home - Dedicated Design Remodel Transform your home with expert remodeling services.

Like

To Study In Ireland is a very enriching proposition as the nation is well versed with English languages and ensures certainty to be fulfilled while addressing the preliminary requisites . There is always an ongoing question in the minds of candidates that what is the   age limit for masters in Ireland and usually students who are 17 years of age can apply. Students need to qualify the IELTS , TOEFL and PTE and have to secure a minimum of 50 to 70% grade while being able to accomplish a provocative degree program in Ireland .

Visit: https://educationvibes.in/country/Study-Abroad/Ireland

 

Like

Completing assignments on time while maintaining quality is a challenge for many students. Whether you’re dealing with essays, research papers, or technical reports, academic pressure can be overwhelming. Professional assignment assistance ensures that students receive expert guidance, helping them improve their writing skills and achieve better grades.


With assignment help Australia services, students can access well-researched and plagiarism-free content tailored to their specific needs. These services cater to various subjects, ensuring high-quality solutions within deadlines. Have you ever considered using assignment help? Share your thoughts or ask any questions about your academic challenges!

Like

StudyProfy has been a huge help in managing my academic workload. Their professional writers ensure that every paper is well-researched, properly structured, and delivered on time. As a busy student, it’s hard to balance multiple assignments, but StudyProfy makes it easier with their expert writing services. Whether I need help with an essay or have to pay for research paper assistance, I know I can rely on them for quality work. Their support has been invaluable in helping me achieve my academic goals, and I highly recommend StudyProfy to any student looking for dependable writing services!

Like

Guest
Jul 17, 2023

Mara! I really appreciate your content. This is fantastic, did you make a YouTube tutorial for that? If not I really recommend this, please consider this. Thanks for great tip! :-)

Like
datapeers.png

Address

71-75 Shelton Street, Convent Garden

WC2H 9JQ London

© 2025 by Data Pears Consulting. All rights reserved.

bottom of page