Power BI chart with Multiple columns on each side of the Y -axis( using Dual Y-axis)

[sandy_v]

Hi Gurus,

We are trying to implement a Power BI report where we need to show multiple coloumns on Y axis with timescale on the x-axis. The number of coloumns can be range from 5-6 which needs to be shown on Y-axis. The Dual axis gives us 2 column value on each Y -axis but how should i get say 2 or 3 Col values on each side.

Q- Is it posssible in Standard Power BI?

Q- If customization is required has anyone did this before or what can be used to quickly get this kind of chart?

BR

Sandy

[v-xuding-msft]

Hi @sandy_v ,

You can use the visual of line and stacked column chart and line and clustered column chart to implement dual Y axis. And there are two documents you can reference.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-customize-x-axis-and-y-axis

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart

Choose the visual -- > click  Format -- > Y axis -- > turn on Show secondary.

Best Regards,

Xue Ding

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

[sandy_v]

Thanks v-xuding-msft for your reply.

The issue for us is to have 2-3 column value on Y -axis on each side of dual Y axis. The stacked and combo chart is not what we are developing for this requirement.

One sample example with 3 values on one side of Y-axis is -  

https://images.app.goo.gl/5SGsSLvWjohxPgxT8

BR

Sandeep Vyas

[v-xuding-msft]

Hi @sandy_v ,

It is not supported at this moment. To make Power BI better, you can submit your request at Power BI Ideas and vote it up.

Best Regards,

Xue Ding

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

[sandy_v · Accepted solution]

Thanks. I hope to get this in Power BI. I will post this in idea forum.

BR

SV