How can I add a Summary Total in the chart?

[GabrielDC]

All the charts we use have a Summary total that shows how many items are displayed in all the bars.

How can I achieve this in Power BI? I have searched everywhere but found nothing.We need the bit in the red box

[Anonymous]

Hi @GabrielDC ... This is not possible in power Bi but i did the same thing. These are the Steps:
1. Create the measure:

sum = CALCULATE(SUM('Table'[column]))
2. Paste on the card and it will look like
summary Total

Hope you will get this...
Thanks

[negi007 · Accepted solution]

@GabrielDC  I think there is way around to achive this output. You can use another small visual which is Card visual. This card visual can be used to show the total and you can then place in over your main chart. This way you will be able to view the updated total from the bar chart on to the Card visual.

 

[GabrielDC]

Hi, thanks for this, I tried this however when you maximize the chart in the screen the visual card disappears, is there a way to group them together?

[Anonymous]

Hi,
  If you select all the Kpi's and right click on selected Kpi's it will give you option of Grouping.

Hope You will get this !!
Thanks

[negi007]

@GabrielDCYes there is an option to group items. Please select your chart and the visual showing total then under the Format menu you will get option to group them together. I hope it helps. Further, there is no need to create a seperate measure.

[mahoneypat]

Can you just add a card visual with the same measure as in the chart and put it over the corner of your chart?

If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat