line and clustered bar chart in power bi.

[DRobson]

Hi all, 
I have a line and clustered bar chart in power bi.
The bar chart axis is in percentages, whereas the line is numerical.
I want to add another line to the chart, but to the same axis as the bar chart (It will represent a target %)
Is this possible with the default visual, or do I need a custom visual? If so, can anyone reccommend anything?

[DRobson · Accepted solution]

For anyone needing a solution here, I reccommend the custom visual: Dual Y axis combo chart.

[v-zhangti]

Hi, @DRobson 

Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel. I look forward to your response.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DRobson]

Hi is a screenshot from the table I want to re-create from excel:
The chart is a clustered column chart showing the min and max values of a data column per week.
There is also a line axis showing the average per week. As you can see, all three lie on the same axis. If I use the line and clustered column visual in power bi, the line gets added to its own axis. does anyone know a good custom visual alternative here?

[DRobson]

I don't suppose there is a 3rd party one you recommend?

[dk_dk]

Normally you would be able to add a constant line to a bar chart from the Analytics menu, but for some reason the combined line an bar chart only allows error bars to be added, not constant lines.

If your target is very static and constant across the categorical axis (the bars) thne you could cheat it by forcing the y axis to always start at 0% and end at 100%, and then just adding a horizontal line graphic in the correct place. Otherwise you probably would need a 3rd party visual.

[DRobson]

Do you know a third party visual I can use?