Forum Discussion
stacked column chart with overlapping columns
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??
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!
6 Replies
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 not sure what you are trying to achieve, what you mean by number overlap? Can you elaborate a bit more?
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
Anonymous , there are few options for label position.
Format - data label position. try if it can helpIs it possible in Power BI to create a bar chart that looks like this? This is overlapping bars.
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:
- Min Val = MIN(Table[Column])
- Min to Avg Val = AVERAGE(Table[Column]) - Table[Min Val]
- Avg to Max Val = MAX(Table[Column]) - Table[Min to Avg Val]
Then use a stacked column chart with the following values in the Y-axis:
- Min Val
- Min to Avg Val
- Avg to Max Val
