Add total bar to bars in clustered column chart

[SpikeSpiegel_3]

This is the clustered column chart I created and I want to add total bar for each month, so the status is (total, done, in progress, new) and each month has 4 bars for the 4 status. Is there any way to get it done ?

[Anonymous · Accepted solution]

Hi @SpikeSpiegel_3 ,

According to your description, here are my steps you can follow as a solution.

(1) This is my test data.  

(2) We can create a calculated column.

Month = FORMAT('Table'[date],"mmmm")

(3) We can create a table.

Table 2 = var a=SUMMARIZE('Table','Table'[status])
var b={"Total"}
var c=SUMMARIZE('Table','Table'[Month])
return GENERATEALL(c,UNION(b,a))

(4) We can create a measure.

Measure = 
var _a=CALCULATE(SUM('Table'[value]),FILTER(ALLSELECTED('Table'),'Table'[Month] in VALUES('Table 2'[Month]) && 'Table'[status] in VALUES('Table 2'[Status])))
var _b=CALCULATE(SUM('Table'[value]),FILTER(ALLSELECTED('Table'),'Table'[Month] in VALUES('Table 2'[Month]) ))
return IF(SELECTEDVALUE('Table 2'[Status])="Total",_b,_a)

(5) Then the result is as follows.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[zenisekd]

To do this, you would have to add some changes to your tables or calculate a special table from which you would display this. I can tell that it is not tbe best solution... I would suggest perhaps to use the "line and clustered column chart" to display this. Disable the secondary axis and play out with the markers..?

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart?tabs=powerbi-d...