Having multiple Y axis dynamically in a single line chart Power BI

[asgharhussaini]

Hi there,

I need a solution (Power BI) to develop a line chart that can display 3 or more Y-axes. Each time I add a measure, a new Y-axis should appear and show the corresponding plot. Could you please provide a solution for this requirement?

Thank you.

Contact Person: Asghar Hussaini

Cell# +923262281725

Time Zone: Pakistan Standard Time (PST)

Contact Time: 10 AM - 19 PM (Mon - Fri)

[v-linyulu-msft]

Hi,@asgharhussaini 

Regarding the issue you raised, my solution is as follows:

1.First, you can try customizing your visuals in R, and here's the sample code:
Multiple axes in R (plotly.com)
 

Create advanced analytics and visualizations using R scripts - Power BI | Microsoft Learn
 

2.Second, you can try using python for custom visuals, here's the relevant sample code:
Multiple axes in Python (plotly.com)
 

Create Power BI visuals using Python in Power BI Desktop - Power BI | Microsoft Learn
 

Finally, I found a custom visual that matches your requirements that you can try out.

Of course, if you have any new ideas, you are welcome to contact us.

Best Regards,

Leroy Lu

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

[asgharhussaini]

Hi @v-linyulu-msft 

I want to add measures dynamically like parameters, whenever user select measures in filter a new plot created with new YAxis. The user should be able to deselect or remove any measure from chart.