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 t...
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!
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?