Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
tbwopsm
New Member

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

tbwopsm_0-1687348122848.png

 

The two % fields aren't correct as they are just summing up the data

 

Any help would be much appreciated

 

Thank you

2 REPLIES 2
SamInogic
Super User
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,

pic1.png

 

On required columns Update as don't Summarize,

pic2.png

pic3.png

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/

Inogic Professional Services: Power Platform/Dynamics 365 CRM
An expert technical extension for your techno-functional business needs
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://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%

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.