why is it showing wrong percentage value (even when it is predefined)

[Sid25]

I don't know what's wrong and unable to figure it out by myself, the percentage value is predefined in the sheet itself, but still, it is displaying the percentage in the wrong format.when I click on it which renders it further line chart and so on, the last phase showing the data right way, I can't figure out what's wrong with first two, even if I change the order, it always shows the data right for the last one.

the percentage value on the line chart looks like this:......

and nothing special about data.it simply looks like this:...

Year	Month	District	Private Hospital	Private Hospital %	Govt. Hospital	Govt. Hospital %	Total
2012	January	Ajmer	0	0	0	0	0
2012	February	Ajmer	0	0	0	0	0
2012	March	Ajmer	0	0	0	0	0
2012	April	Ajmer	0	0	0	0	0
2012	May	Ajmer	0	0	0	0	0
2012	June	Ajmer	0	0	0	0	0
2012	July	Ajmer	0	0	0	0	0
2012	August	Ajmer	0	0	0	0	0
2012	September	Ajmer	0	0	0	0	0
2012	October	Ajmer	8431	87.8	1172	12.2	9603
2012	November	Ajmer	7559	84.85	1350	15.15	8909
2012	December	Ajmer	8409	83.48	1664	16.52	10073
2013	January	Ajmer	8252	84.26	1541	15.74	9793
2013	February	Ajmer	8332	84.17	1567	15.83	9899
2013	March	Ajmer	9033	84.83	1615	15.17	10648
2013	April	Ajmer	9469	82.24	2045	17.76	11514
2013	May	Ajmer	9568	78.19	2669	21.81	12237
2013	June	Ajmer	10310	82.23	2228	17.77	12538
2013	July	Ajmer	11123	80.2	2746	19.8	13869
2013	August	Ajmer	9767	81.43	2228	18.57	11995
2013	September	Ajmer	9615	79.5	2479	20.5	12094
2013	October	Ajmer	9222	78.62	2508	21.38	11730
2013	November	Ajmer	9246	81.2	2140	18.8	11386
2013	December	Ajmer	9132	79.28	2387	20.72	11519

please, guide me through how to get it done.

Thanks in Advance

[amitchandak]

@Sid25 , In case you have Percent column that is Already multiplied by 100, then divide it by 100, if you plan to mark it as a % column.

% column means A/B, not A/B*100

[Sid25]

I am kinda new to this platform as I used to work on r and python, could you please tell me exact pattern or formula to get it done.

I beg your pardon for asking spoon-feeding but for power bi, we gotta know the exact keyword to search the problem regarding the occurred issue.

thanks in advance and sorry for bothering you again.

[amitchandak · Accepted solution]

@Sid25 , Once you click on the field , You will see. No % sign with slight dark background means checked. unchecked in this case.

Once you check that value will display *100. Means .01 is 1%. So if you already have value as 1 (in % column) then you need to create a column [% Value]/100 and then use % formatting