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:
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).
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.
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.
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.
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.
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.
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