Forum Discussion
Plotting Multiple Data Points on Secondary Axis
Hello,
I'm attempting to recreate excel charts with multiple data points on the secondary axis in Power BI. I have been unsucessful so far in doing so, as I haven't discovered a chart that will allow multiple data points on the secondary axis to be shown. I have included an example of what I'm trying to accomplish below.
Hi TWilliams3
I think you want to build a same visual like your screenshot in excel.
You can try to build a line and clustered column chart and turn on Show secondary in Y axis to show the second axis.
For more details you may refer to this blog: Create a combo chart with two axes
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
TWilliams3 there is no straightforward way to do this in Power BI, basically whatever you want to show on the x-axis needs to be in a table and then it is easy to control with measures.
Thank you, Parry
Hi TWilliams3
I think you want to build a same visual like your screenshot in excel.
You can try to build a line and clustered column chart and turn on Show secondary in Y axis to show the second axis.
For more details you may refer to this blog: Create a combo chart with two axes
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you, I will give it a try!
