Change the Total in a table visualization to be a %

[tbwopsm]

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

[SamInogic]

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 crm@inogic.com

Services:  http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

[tbwopsm]

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%