Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 ?
Solved! Go to 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.
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.
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...
User | Count |
---|---|
93 | |
83 | |
77 | |
71 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |