Forum Discussion
Having multiple Y axis dynamically in a single line chart Power BI
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)
2 Replies
- AnonymousNot applicable
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
- asgharhussainiFrequent Visitor
Hi Anonymous
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.