The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
hi,
table below should give this chart in Power BI but in standard 'Line and stacked column chart' I cannot choose x axis for measure 1. Trendline on secondary axis is possible in PBI but that is not the result a I get in Excel custom chart.
Does this chart also exists in Power BI ?
data:
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
dataA | 10 | 15 | 35 | 20 | 45 | 40 | 5 | 35 | 20 | 45 | 40 | 60 |
dataB | 20 | 15 | 35 | 10 | 5 | 5 | 5 | 10 | 35 | 55 | 50 | 35 |
dataC | 50 | 40 | 55 | 40 | 60 | 65 | 55 | 40 | 70 | 65 | 65 | 40 |
running total | 80 | 150 | 275 | 345 | 455 | 565 | 630 | 715 | 840 | 1005 | 1160 | 1295 |
measure1 | 65 | 70 | 85 | 85 | 80 | 90 | 90 | 95 | 85 | 90 | 90 | 100 |
Chart in Excel
Solved! Go to Solution.
Hi @BIuser09,
Thanks for reaching out to the Microsoft Fabric Forum Community.
Power BI does not support true "Combo Charts" like Excel, where you mix scatter + line + column with full axis control.
If this helped, please mark the response as the accepted solution and give it a thumbs-up so others can benefit too.
Best regards,
Prasanna Kumar
Hi @BIuser09,
Just a gentle reminder has your issue been resolved? If so, we’d be grateful if you could mark the solution that worked as Accepted Solution, or feel free to share your own if you found a different fix.
This not only closes the loop on your query but also helps others in the community solve similar issues faster.
Thank you for your time and feedback!
Best,
Prasanna Kumar
Hi @BIuser09,
We wanted to kindly check in to see if everything is working as expected after trying the suggested solution. If there’s anything else we can assist with, please don’t hesitate to ask.
If the issue is resolved, we’d appreciate it if you could mark the helpful reply as Accepted Solution it helps others who might face a similar issue.
Warm regards,
Prasanna Kumar
Hi @BIuser09,
Just following up to see if the solution provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.
If the response addressed your query, kindly mark it as Accepted Solution and click Yes if you found it helpful this will benefit others in the community as well.
Best regards,
Prasanna Kumar
Thanks for the answer but this is not what I want.
I would like to add 'measure1' as a line or marker connected to the data on the FIRST Y axis. NOT the 2nd Y axis
Hi @BIuser09,
Thanks for reaching out to the Microsoft Fabric Forum Community.
Power BI does not support true "Combo Charts" like Excel, where you mix scatter + line + column with full axis control.
If this helped, please mark the response as the accepted solution and give it a thumbs-up so others can benefit too.
Best regards,
Prasanna Kumar
Hello @BIuser09
Here you can try
Thanks,
Pankaj Namekar | LinkedIn
If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
User | Count |
---|---|
69 | |
64 | |
62 | |
55 | |
28 |
User | Count |
---|---|
112 | |
81 | |
65 | |
48 | |
38 |