How to create bullet point chart

[rickferreiran]

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 

[uzuntasgokberk · Accepted solution]

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 |

[DataNinja777]

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,