Forum Discussion
Clustered Bar Chart with dual Labels (Sum + Count)
Hello PowerBI Community,
I am a new user transitioning from Tableau. I have a seemingly easy task but I have been unable to figure it out.
I am trying to create a clustered bar chart which has two labels (total and count of deals). I am easily able to create the bar chart and display the totals, however I am unable to add the second label.
PBIX here: https://www.dropbox.com/s/jd2sv8hc27ndykj/help123.pbix?dl=0
I want to include the count of commitments on each bar. The end result would be the chart below but in bar chart format:
| ABC | 67 | 2 |
| DEF | 300 | 1 |
| EFG | 160 | 3 |
| HIJ | 180 | 5 |
| KLM | 110 | 2 |
Here is the raw data:
| Fund | Deals | Commitment |
| ABC | Deal A | 30 |
| ABC | Deal B | 37 |
| DEF | Deal C | 300 |
| EFG | Deal D | 100 |
| EFG | Deal E | 20 |
| EFG | Deal F | 40 |
| HIJ | Deal G | 20 |
| HIJ | Deal H | 30 |
| HIJ | Deal I | 40 |
| HIJ | Deal J | 70 |
| HIJ | Deal K | 20 |
| KLM | Deal L | 50 |
| KLM | Deal M | 60 |
Any help would be appreciated.
3 Replies
Vexorg ,
You can have only one either of sum of commitment of the count of deals in Y-axis if you are adding Fund in the legend field but if you removes the legend you are able to add as many as measure values in the Y-axis.
If you need legend then you are allowed to have only one measure value in Y-axis, so you can make use of tooltip option to show the count.Thanks,
Arul
You can create a summarized table with the following formula:
Summarize Table = SUMMARIZE(ALL(Funds), Funds[Fund],"Count",CALCULATE(DISTINCTCOUNTNOBLANK(Funds[Deals]),ALLEXCEPT(Funds,Funds[Fund])),"Sum",CALCULATE(SUM(Funds[Commitment]),ALLEXCEPT(Funds,Funds[Fund])))
