All Content
Timespan
explore our new search
How to create a lollypop chart in Power BI
Power BI
Jun 5, 2023 9:00 AM

How to create a lollypop chart in Power BI

by HubSite 365 about Data Pears

Data Visualization 📊 | Data Storytelling 🎨 | Power BI Consulting 💻 | Power BI Training | Power BI Coaching

Data AnalyticsPower BILearning Selection

In this video, I will show you how to create a lollypop chart in Power BI using just standard visuals and error bars. What do you think of this lollypop chart?

How to create a lollypop chart in Power BI In this video, I will show you how to create a lollypop chart in Power BI using just standard visuals and error bars. What do you think of this lollypop chart? Yay or nay? Let me know in the comments!!

Link to learn more about the new On Object Interaction feature in Power BI: learn.microsoft.com/en-us/power-bi/crea…

 

A "Lollipop Chart" is a variant of the bar chart, developed for easier reading and interpretation. It uses a circle to denote the data point value, with a line extending to the axis. This makes the actual value stand out clearly.

Here's a basic method of creating a Lollipop Chart in Power BI using a combination of bar and scatter plot:

  1. Begin with a standard bar chart and input your values. For the bars, use a field with all values being the same so that you have a straight line (you could create a new column in your data set that's just a constant value, for example).

  2. Overlay a scatter plot on top of your bar chart. Assign the same fields to the scatter plot as you did the bar chart for both axes.

  3. Adjust the size of the scatter plot points to create the 'lollipop' effect, and make sure they align with the ends of the bars from the bar chart.

  4. You can then adjust colors, labels, and other formatting as needed.

Please note, Power BI has seen multiple updates since my last training data in September 2021, so it's possible that there have been changes or additions to the available chart types or the process to create custom ones.

Discover More About Lollypop Charts in Power BI

A lollypop chart is an innovative way to display data in Power BI. It combines the functionality of a bar chart with the visual appeal of a circle, providing an engaging and intuitive representation of your data. By utilizing standard visuals and error bars, you can create a lollypop chart in Power BI to add a fresh perspective to your data storytelling. Explore the On Object Interaction feature, join a Power BI Report Design Bootcamp, or dive into recommended books to enhance your knowledge and become a master in Power BI data storytelling.

Learn about How to create a lollypop chart in Power BI

 

In this article, we will learn how to create a lollypop chart in Power BI using just standard visuals and error bars. We will also learn about the new On Object Interaction feature in Power BI and how to access it. Additionally, we will discuss how to join the Power BI Report Design Bootcamp and become a Power BI Data Storytelling Master. Lastly, we will learn about some books which can help us in our Power BI journey.

The lollypop chart is a useful way to visualize data and compare the values of different data points. To create this chart in Power BI, we can use standard visuals such as bar charts and error bars. The On Object Interaction feature in Power BI can also be used to create a lollypop chart, and can be accessed by going to learn.microsoft.com/en-us/power-bi/create-reports/power-bi-on-object-interaction.

To become a Power BI Data Storytelling Master, we can join the Power BI Report Design Bootcamp. This bootcamp teaches us how to design and build stunning Power BI reports to help us effectively communicate our data insights. We can join the bootcamp at powerbiacademy.datapears.com/courses/pbidesignbootcamp.

Finally, we can read books which can help us in our Power BI journey. Some books which are recommended for Power BI are "Storytelling with Data", "How Charts Lie", "Knowledge Is Beautiful" and "Microsoft Power BI Cookbook". These books can provide us with useful information and tips to help us in our Power BI journey.

 

More links on about How to create a lollypop chart in Power BI

Lollipop Charts In Power BI Custom Visual
Creating Lollipop Charts ... First, bring Issue Type to the Y-Axis of the canvas. Then, select the rectangle shape in Marks and place it in the Glyph. Click Stack ...
Lollipop Column Chart
Standard column charts are ideal for showing a single measure per category so you can easily compare each of the categories with the rest.
Lollipop Column Chart for Power BI
The Lollipop Column Chart shows a marker (mostly a dot) per category. A subtle line connects the icon to the measure-axis origin. The icon combined with the ...
Create Lollipop Column Chart for Power BI | PBI VizEdit
From Visual Editors page, you can go to library, choose the Lollipop Column Chart visual and import the visual. Lollipop Column Chart Once you click on import, ...
Matrix/table visual with lollipop chart
Solved: Hello! I am wondering if it is possible to add such lollipop-like lines to a power BI table or matrix visual. I could not find this option.
Lollipop Chart - Custom Visuals
The lollipop chart is a chart usually made up of lines and circles. Like a bar chart, a lollipop chart is used to easily compare a single measure for ...

Keywords

Create Lollypop Chart in Power BI, Visualize Data with Power BI, Power BI On Object Interaction, Power BI Report Design Bootcamp, Storytelling with Data, Charts Lie, Knowledge Is Beautiful, Microsoft Power BI Cookbook