Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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!
@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!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 88 | |
| 82 | |
| 68 | |
| 64 |