Transform to %

[Anonymous]

Hi team, 

My datasource is Sharepoint

1. When i create a Card - I cannot get the below to pull through as a %.
2. I have 3 columns with Audit Scores, how can i add a column and get an average

[Anonymous · Accepted solution]

Hi @Anonymous ,

Which field or measure you are applying on the card visual? You can select that field or measure and set the Format as Percentage in Column tools or Measure tools ribbon just as shown in below screenshot.

Percents and decimals in visual – Power BI

What's the calculation logic of average? Is that for the average of AuditScore1,AuditScore1 and AuditScore3 just as the field Averge of below table? If yes, you can create a measure as below to get the average:

Items	AuditScore1	AuditScore2	AuditScore3	Calculation logic	Average?
Item01	80	76	92	=(80+76+92)/3	82.66667
Item02	78	84	68	=(78+84+68)/3	76.66667
Item03	98	89	96	=(98+89+96)/3	94.33333

Average = DIVIDE(SUM('Table'[AuditScore1])+SUM('Table'[AuditScore2])+SUM('Table'[AuditScore3]),3,0)

Otherwise, please provide some sample data (exclude sensitive data) and your expected result with specific examples and calculation logic. Thank you.

Best Regards

[Anonymous]

To transform to %, select the column and on Column tools (top menu) click on the % icon

To get the average, I would suggest creating a measure instead: Audit_Score_Avg = AVERAGE(SUM(AuditScore1) + SUM(AuditScore2) + SUM(AuditScoreN))