Forum Discussion
How to create bullet point chart
Hello I need to built a chart like this:
Where each circle represents one project and the color is related to the status.
There will be a tooltip with the name of the project when mouse over.
Be able to do a drill through to go a page with project details on the bullet point.
Does anyone know how to do that?
Thanks
Hello rickferreiran ,
I would probabaly create a table or matrix visualization and put values into it. Then, I would set up a conditional formatting rule with icons and enable drillthrough functionality.Kind Regards,
Gรถkberk Uzuntaล
๐ If this post helps, then please consider Accepting it as a solution and giving Kudos โ it helps other members find answers faster!
๐ Stay Connected:
๐ Medium |
๐บ YouTube |
๐ผ LinkedIn |
๐ท Instagram |
๐ฆ X |
๐ฝ Reddit |
๐ Website |
๐ต TikTok |
2 Replies
Hello rickferreiran ,
I would probabaly create a table or matrix visualization and put values into it. Then, I would set up a conditional formatting rule with icons and enable drillthrough functionality.Kind Regards,
Gรถkberk Uzuntaล
๐ If this post helps, then please consider Accepting it as a solution and giving Kudos โ it helps other members find answers faster!
๐ Stay Connected:
๐ Medium |
๐บ YouTube |
๐ผ LinkedIn |
๐ท Instagram |
๐ฆ X |
๐ฝ Reddit |
๐ Website |
๐ต TikTok |Hi rickferreiran ,
To create a bullet point chart in Power BI where each circle represents a project and its color reflects the status, you can use a scatter chart. First, ensure your dataset includes fields for project name, X and Y positions (to control the grid layout), project status (to determine color), and project ID (for drill-through functionality). Insert a scatter chart and map the X and Y positions to their respective axes, use project status as the legend, and set a constant size for the markers to maintain uniform circles. Remove the axis labels and gridlines to create a clean layout, and apply custom colors to reflect different project statuses. The tooltip should display the project name so that hovering over a circle reveals details. To enable drill-through functionality, create a separate report page where project details can be displayed and configure the drill-through filter using the project ID. Clicking on a circle should then take users to a detailed project view. For more customization, consider using Deneb, a Vega-Lite-based visual for Power BI, or Charticulator, which allows more precise control over the layout and formatting of the circles. Deneb, in particular, enables you to define a JSON script that lays out the circles in a structured grid while supporting interactivity like tooltips and drill-through.
Best regards,
