Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I need to show the total at the bottom of a data table in a grouped column chart in Power BI, that is, this total which is found here at the bottom of the table:
I want to show it as a value in a grouped column chart next to the value of 387 as follows:
It is important to make it clear that the columns from which the value is obtained 4:7 4:42 5:38 are columns made from a measure, that is, a DAX formula was used for its elaboration, for this reason I am not allowed to drag the column to the Values section in the clustered column chart, every time I try to place it in Values it automatically moves to Tooltip.
The column PromedioHoraPlanta is the one that corresponds to the total displayed value of 4:7 in the table.
I would like someone to give me guidance on how to place the total in the grouped column graph
Hi @sebastianslz you might need to create an aggregate calculated table (e.g. https://docs.microsoft.com/en-us/dax/summarize-function-dax) and recreate your measures as calculated columns so you can use them as values in the column chart.
I'm not sure the column chart will handle displaying your ratio values though - I think they'd be interpreted as text which will default to using a count aggregation when you add them to the visual. You might need to convert them as a percentage or decimal.