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...
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:
- 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