Forum Discussion
Need help with Line and Stacked Column chart
I am building a line and stached column chart, where:
The stacked columns are actaul revenue by business groups, in
One line graph is the budgeted revenue (no need to seperate by business groups)
One line graph is a ratio in %
Is there anyway to have the stacked columns and budget line graph use the y-axis on the left, and ratio line use the y-axis on the right side? It seems to me the visiual is designed with the two line graphs have to share the y-axis on the right side. But I am hoping there is some settings to allow me change that.
I am also open to suggustions if there are other custom visual that can presents all the required data in one visual. Thanks in advance for everyone's help!
2 Replies
Power66 , The stacked bar and line, can share Left Y axis if needed (If you switch of Secondary axis). But Stacked will not use a secondary(right) y-axis.
You can log an idea- https://ideas.powerbi.com/ideas/
Thanks for your attention. I understand the stacked column can only use the left y-axis. And the line graph can share the left y-axis with the stacked column. What I need is to split the two line graphs: with one line graph shares left y-axis with the stacked column, and the other line graph uses the right y-axis. Is that possible? If yes, how? Thanks again for your help!
