Welcome!

By registering with us, you'll be able to discuss, share and private message with other members of our community.

SignUp Now!

Multiple axes line chart in Power BI

Member
Joined
Feb 3, 2023
Messages
131
Each line has to have its own y-axis (own scale and color). The lines are from categories (like an ID) that need to be selectable with a slicer.
I have tried many custom graphs, but none seem to match my requirements. Plotly has functionality to build such graphs, but it is not supported in the python visual and it does not work in the R visual. I tried the plotly.js visual with the https://github.com/plotly/react-chart-editor editor. I could build the right graph but for each "trace" I had to manually filter out the ID's of the separate lines, instead of doing it with a slicer.
Quick attempt with plotly.js in Power BI looks like this: Quick attempt with plotly.js in Power BI
I'd rather avoid writing my own custom visual, but any advice or tips are welcome.
 
Top