Create a Lollipop Chart in Power BI -- Without the use of any Custom Visuals

 I have been playing around with the newly launched Error Bars functionality in Power BI.  The result is this Blog Post.  Here I am going to explain how you can create a lollipop chart in Power BI without using any custom visuals or charticulator or deneb 

Step 1:  

Create a simple line chart -- I have sales data and region data.  So I created a line chart as shown below.

Step 2:  

Format the line chart to remove the line as shown below.  Click on the format icon -- Visual tab -- Line -- Stroke Width -- Change from 3 px to 0

The result of this action is -- the line will entirely disappear as we changed the Stroke Width from 3 px to 0 px.

Step 3:  

Add Markers as shown below and ensure that the shape is a circle resembling the ball of the lollipop and increase the size to 10 px to get reasonable sized balls

The result is as shown below.

Step 4:  

Ensure that the Data Labels are Enabled and choose Position as Above as shown below

You can disable Y-Axis if you need to.  

Step 5:  

Here is where we will be using the Error Bars to add the Line to show the lollipop stick.

To go to the Error Bars section -- Go to the Further Analytics icon and click on Error Bars.

Enable the Error Bars.  As shown below it needs an Upper Bound and Lower Bound.  Upper Bound can be Sum of Sales and the Lower Bound is always 0 (Zero).  Since there is no way to input a number, let us create a Measure that returns 0 .  

The new Measure is -- Lowerbound = 0

 

Step 6:

You can see faint lollipop lines.  You can increase the width of the line by clicking on the Bar and changing the Width as shown below

And Viola!  Your Lollipop chart is ready!

Hope you liked this Step by Step instruction on creating the lollipop chart.