topic Re: Overlap bars in clustered chart in Custom Visuals Development Discussion

Overlap bars in clustered chart

Anonymous — Fri, 12 Jul 2024 00:30:03 GMT

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!

Re: Overlap bars in clustered chart

Anonymous — Fri, 12 Jul 2024 05:21:47 GMT

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!

Re: Overlap bars in clustered chart

Anonymous — Mon, 05 Aug 2024 21:39:28 GMT

Hi! Thank you so much for the response

The logic works. But PowerBI automatically shows the values in % instead of just points. How do I tackle that?

Re: Overlap bars in clustered chart

Anonymous — Tue, 06 Aug 2024 00:12:04 GMT

Hey!
Great to hear it works. Not sure exactly the issue, but it could be that you have selected the "100% Stacked Column Chart" instead of the "Clustered Column Chart". Could you look at the visual selector pane and see if there is another option?

Re: Overlap bars in clustered chart

qqqqqwwwweeerrr — Wed, 07 Aug 2024 13:08:47 GMT

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/@Howtosolveprobem

Regards