Description
Standard bar charts are ideal for showing a single measure per category. You can easily compare each of the categories with the rest. However, if you have larger number of categories (>10) in a bar chart it is possible the chart itself becomes “heavy”. The coloured bars will fill large part of the chart surface. To avoid this clutter one can use the Lollipop Bar Chart for Power BI as an alternative.
The Lollipop Bar 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 line make it a Lollipop Bar Chart.
Key features of the Lollipop Bar Chart
-
Format the objects: By selecting a specific color and size you can format the data point objects (dot and line). You can switch the linking line on or off. And for the dot one can switch on/off the fill color;;
-
The Axis formatting options are in line with the options you know from the Power BI Clustered Bar Chart, so no need to learn a new interface;;
-
Selection & Highlighting: Like in standard Power BI Charts you can make use of the Selection & Highlighting functions within the Lollipop Bar Chart;
-
Context menu: Like in standard Power BI Charts you have access to the context menu to Include/Exclude data points;
-
Full tooltip support: Besides the default Tooltip behaviour (show the value of the element you hover) you can also add additional feeds to the tooltip.
Watch the video tutorial of the Lollipop Bar Chart for Power BI HERE. Do you want to try the Lollipop Bar Chart yourself? Download it from the Microsoft AppSource for free.
Simple Solutions –
This is an underappreciated visual, a lollipop bar chart is excellent to reduce the amount of color of bar chart and it is easier to observe small differences from bars. A must have.