Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Percentage value correction

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 ...
Need Help
v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

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's avatar
Anonymous
Not applicable
4 years ago

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's avatar
    v-chenwuz-msft
    Community Support
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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's avatar
        v-chenwuz-msft
        Community Support
        4 years ago

        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.