Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |