How to show percentage in data and visual also

[Sriku]

Hi,

I have 2 column divided to get percentage but I am seeing only 0.0 even after changing the data type to whole number, percentage

if [Pending]= 0 then 0 else [overdue]/[pending]

Pending	Overdue	Percentage
18	0	0.00
17	607	35.71
245	4	0.02
33	10	0.30
12	0	0.00
23	3	0.13
2	1	0.50
62	0	0.00
55	0	0.00
236	1	0.00
4	1	0.25
4	1	0.25
132	2	0.02

[v-shex-msft · Accepted solution]

Hi @Sriku,

Did these replay help with your requirement? if this is a case, you can consider accepting the suitable one as a solution to help other users to find out the suggestion that faced a similar issue.

If not, you can feel free to post here with detailed descriptions.
Regards,

Xiaoxin Sheng

[zammikahan]

If you change the data type to "Whole Number", your decimal places will be ommited (so that you get zero's).

Change the data type to "Decimal Number" and Format to "Percentage".

[jdbuchanan71]

@Sriku 

You want to chage the Format of the measure to Percentage: