cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sebastianslz
Frequent Visitor

How to display the table Total in grouped column chart

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:

sebastianslz_2-1632168680827.png

I want to show it as a value in a grouped column chart next to the value of 387 as follows:

 

sebastianslz_3-1632168711320.png

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.

sebastianslz_4-1632168759203.png

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

1 REPLY 1
halfglassdarkly
Resolver I
Resolver I

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.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.