Dual axis chart

[Anonymous]

Hi all,

I have a requirement to use a dual axis chart with Budget,Spent and Variance. Variance should be in a line and the expecatation was to use something like a bullet chart format to show budget and spent, that is we want to show out of the budget , how much is spent and this can be claerly shown in bullet format.

As there is no vsual with bullet and line together, I have used column and line chart,but this looks crowded when the data labels are turned on.

Is there a way I can turn on data labels for only variance and turn it off for budget and spent?

Or please suggest if there is a visual with bullet and chart.

Thank you

Poojitha

[Anonymous]

Hi @Anonymous ,

Take a look at this visual see if it suits your need.

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200000183?src=office&tab=Overview

Best Regards,

Jay

[Anonymous]

Hi,

This visual does not have an option to show "variance" in line, we have an option to only use columns.

Thank you

Poojitha