Percentage value correction

[Anonymous]

Hi All,

we  have some percentage value basis on single direct column on the card visualization which we need to modify with only two digits percentage  and I have adjusted /reduced percentage digit also in power bi desktop.

example: we have  value like this -144424% and we need to modify it to 14 % .  Kindly help how to display two value digit percentage on the card visualization   .

Thanks,

Raghu

[v-chenwuz-msft]

Hi @Anonymous ,

You want always display the first and second number of this vaule?

Maybe you can try this:

var _len = len(SUM(final[region_involvement_score]))

return

SUM(final[region_involvement_score])/POWER(10,_len)

Best Regards

Community Support Team _ chenwu zhu

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

[Anonymous]

Hi Chenwu,

i have tried but still no luck. i want to show pecentage on single  column using card visuvalization .

PFbelow  screenshot.

Thanks,

Raghu

[v-chenwuz-msft]

Hi @Anonymous ,

Use FORMAT( [values], "00%" )

Or modify the result as the screenshot.

Best Regards

Community Support Team _ chenwu zhu

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

[Anonymous]

HI Chenwuz,

i am new to power bi . can you please provide screenshot for to get two numbers percentage?

i have tried below changes  still not getting 

i need to show like this

Thanks,

Raghu

[v-chenwuz-msft]

Hi @Anonymous ,

I put my pbix file in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

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

[Anonymous]

Thanks for sharing PBIX file. here i need to display percntage value based on sigle column i dont have any other columns which shared above post.

Kinldy help..

Thanks,

Raghu

[Anonymous]

Hi Amit, i have donr like this -

SUM(final[region_involvement_score])/100 still getting same value .

Thanks,

Raghu

[Anonymous]

Still getting same value . could you please send formula ?

[amitchandak]

@Anonymous , I think first divide the actual value by 100 and then mark it as a percent column.

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

Hi Amit, i have done like this -

SUM(final[region_involvement_score])/100 still getting same value .