Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
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/
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%
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
109 | |
108 | |
93 | |
61 |
User | Count |
---|---|
171 | |
139 | |
133 | |
103 | |
86 |