Forum Discussion
Overlap bars in clustered chart
Hi community!
I am trying to create a clustered bar chart that shows the total points vs accepted points for tickets in a bar plot. The dataset has ticket name, accepted points, total points and target date. When I drag and drop accepted and total points in the x-axis and ticket name in the y-axis, I see bars side by side to each other. I understand that's how a clustered bar chart works. But I want to display the bars overlapping one another and add a constant line for target date which should be set to today.
What I have now:
What I want: (This plot was generated using Python code and I am trying to achieve this in Power BI
Any help is much appreciated. Thanks!
Hi there,
To achieve this in Power BI, you have to use slightly different logic. What you will need is a measure that calculates the difference between the accepted and remaining values rather than use the totals and overlap the columns. You will then use this calculated measure as the new "Remaining" value and put them into a "Stacked Column Chart" together.
If this doesn't work, you could upload a sample file and I can try offer another solution.
Good luck!
4 Replies
Hi there,
To achieve this in Power BI, you have to use slightly different logic. What you will need is a measure that calculates the difference between the accepted and remaining values rather than use the totals and overlap the columns. You will then use this calculated measure as the new "Remaining" value and put them into a "Stacked Column Chart" together.
If this doesn't work, you could upload a sample file and I can try offer another solution.
Good luck!Hi Anonymous
This is not exact solution but this will help to get a path with some modifcations it can be solved i guess: https://youtu.be/wDNxTwiPg8k
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: www.youtube.com/@HowtosolveprobemRegards
