This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
I have a clustered column chart with data that I'd like to split up but still visualize on the same page. I added another field to essentially denote which category the records belong to, and I'd like to split up by category (CAT1 and CAT2). If possible, I'd like to add in the second y-axis but that seems like a stretch.
What would be a good way to visualize this? My last resort would be just concatenating the category name into the field labels, but I'd like a more high level visual to show the split. End goal is the attached picture - nothing fancy, maybe a different background for the right side would help but isn't required
HI, @kimchizal
Currently only Combo Charts have the second y-axis, you may try to add "CAT1" values into Column Values and
"CAT2" values into Line Values. then enable second Y-axis in Format->Y-axis->Show secondary
For example:
Reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart
Best Regards,
Lin
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 30 | |
| 24 | |
| 23 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 61 | |
| 35 | |
| 29 | |
| 23 | |
| 22 |