March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Dear community,
I have the visula below:
which is a line and clustered column chart. The problem here is that the numbers in each column are coming on top of each other, instead of starting from zero, and that ends up to a max in my y axis which is wrong.
How can I start the column values from zero?? In other words how can I make the columns overlap??
Solved! Go to Solution.
Hi @Anonymous ,
Based on my research there is no option in Power Bi like the one which is available in Excel to overlap series.
You can try
https://stackoverflow.com/questions/51721282/overlapping-bar-chart-with-multiple-axis-in-powerbi
https://community.powerbi.com/t5/Desktop/Overlapping-Column-Charts/td-p/57291
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
If you are interested in just the visual, and you can do without the labels, you could create DAX to create the correct overlapping values, such as making new measures:
Then use a stacked column chart with the following values in the Y-axis:
Is it possible in Power BI to create a bar chart that looks like this? This is overlapping bars.
Hi @Anonymous ,
Based on my research there is no option in Power Bi like the one which is available in Excel to overlap series.
You can try
https://stackoverflow.com/questions/51721282/overlapping-bar-chart-with-multiple-axis-in-powerbi
https://community.powerbi.com/t5/Desktop/Overlapping-Column-Charts/td-p/57291
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
@Anonymous , there are few options for label position.
Format - data label position. try if it can help
@Anonymous not sure what you are trying to achieve, what you mean by number overlap? Can you elaborate a bit more?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@parry2k , if you look at the first column, you see two numbers : 1546 and 1745. What I want is that these numbers strat from zero, means the dark blue side of the column (the upper part) should end at 1745, not at 3000
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
91 | |
90 | |
83 | |
73 | |
49 |
User | Count |
---|---|
167 | |
149 | |
98 | |
73 | |
57 |