Particular cell to Percentage format

[Anonymous]

Hi All,

Need you help to change a perticular cell to % if the correspondent row is specific text.

This is how i have the data.

Expected output is as below

Whereever column A is Approval then the correspondent cell in the Column B should be in % format rest all to be in number format 

[v-yanjiang-msft]

Hi @Anonymous ,

The data type of a column is fixed, it cannot have both percentage and number, so you can only do it in measure, you can directly create a measure.

Measure =
IF (
    MAX ( 'Table'[Type] ) = "Approval",
    FORMAT ( SUM ( 'Table'[Score] ), "0%" ),
    MAX ( 'Table'[Score] )
)

Get the result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi,

Thanks for taking time to respond me. % for approval is summing up. I need to visulaize it as it is.

Ex: 

Type	Measure
A	1
Approval	90%
B	2
C	3
D	4
E	5
Approval	92%

[v-yanjiang-msft]

Hi @Anonymous ,

In a visual, the same items are automatically accumulated, if you don't want this, you need to add a new column to distinguish them, for example a index column.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , That will make you measure as text type meausre

Create a score measure

score m=  sum(Table[Score])

then try like

if(Max(Table[Type]) = "Approval"), format([score m],"percent"), , format([score m],"number") )

[Anonymous]

Hi Amit,

Thanks for sharing, but it is not working