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.
Hi,
I want to sum "Talk 3" but when creating graph only count is possible.
Best
Thomas
Solved! Go to Solution.
Hi @Anonymous ,
The column chart's ‘Values’ tag can only visualize numeric types, and SUM([Time]) returns a ‘Time’ type, so it cannot be added to the ‘Values’ tag. Try to use a 'Table' visual or a 'Matrix' visual to visualize your time measure.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You'll need to make a measure for this to work.
Try the following >
Sum of Talk 3 = SUM('Table Name'[Talk 3])
(replace "Table Name" with the name of your table)
Once the measure is created, click onto the measure labelled "sum of Talk 3", then click measuring tools > Format : hh:nn:ss.
Thanks for your input. This is working fine when making a card but when making column chart I can't put the measure in values.
Hi @Anonymous ,
The column chart's ‘Values’ tag can only visualize numeric types, and SUM([Time]) returns a ‘Time’ type, so it cannot be added to the ‘Values’ tag. Try to use a 'Table' visual or a 'Matrix' visual to visualize your time measure.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , Please check these blog to sum duration
https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-using-dax
https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-in-dax.aspx
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageKey=814a2cb4-3cca-4cd1-a620-c467adeaaaf6&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
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 |
---|---|
106 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |