How to create dumbbell or target actual chart in a table

[Anonymous]

How do I create dumbbell or target actual chart in a table.

blue/red dots are actuals. Black dots are targets.

I want target and actual chart to be shown for a combination of product-username-region. Where product, username, region each are in separate column as shown below.

Please help. thanks.

[Anonymous]

Hi Jing,

The screenshot is the expected output. I created that in Tableau. But I have to migrate it to power BI.

The third party external dumbell visuals you have shown does not work for me as I have to publish the visuals.

[v-jingzhang]

Hi @Anonymous 

Currently Power BI doesn't have built-in dumbbell chart visuals. To display target&actual values in the same chart, maybe you can try the clustered bar chart or the matrix visual. Put both target and actual fields in Values well. In a clustered bar chart, the axis can have hierarchy. And in a matrix visual, the row headers and column headers support hierarchy. But the shape will be different from a dumbbell chart.

Create a matrix visual in Power BI - Power BI | Microsoft Docs

May I know how do you want to publish the visuals? Why using a custom visual will be a limitation?

Best Regards,
Community Support Team _ Jing

[Anonymous]

Thanks Jing,

Realised dumbell chart wont be possible in power BI its a limitation.  3rd part visual does not work when I publish and share online on app.powerbi.com

So ended up only using matrix and adding conditional formatting. (used difference between target and actual as a measure for formatting)

[v-jingzhang]

Hi @Anonymous 

Sorry the question description is not clear enough. Which visual are you using currently? Does the screenshot shows the actual result or your expected result? If it's the actual result, how the expected result should be like for a combination of product-username-region?

The Dumbbell Bar Chart visual supports Drill and Expand behaviors. Does this can meet your need for axis hierarchy?

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.