Forum Discussion
Change the Total in a table visualization to be a %
Good Afternoon,
I have a table visualization where I need some of the totals changing to be a % instead of a sum
The two % fields aren't correct as they are just summing up the data
Any help would be much appreciated
Thank you
2 Replies
- SamInogic
Super User
Hi tbwopsm ,
You can use Format column, to show the % by clicking on the "%" icon on the toobar.
You can create below two columns using DAX expressions,
% Answered in 15s = DIVIDE(Table3[Calls Answered],Table3[Calls Offered])
% Answered After 15s = DIVIDE(Table3[Calls Answered in 15s],Table3[Calls Offered])
And Format as Percentage with two decimals,On required columns Update as don't Summarize,
Thanks!
Inogic Professional Services Division
Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!
Drop an email at [email protected]
Services: http://www.inogic.com/services/
Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/
Hi, The information I have in the table is correct. It is the Totals at the bottom which is incorrect. Where it is saying 228.24% it should be 58.28% and where it says 171.76%, it should be 41.71%
