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 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

Need Help

10 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

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

      Hi Amit, i have done like this -

      SUM(final[region_involvement_score])/100 still getting same value .
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Still getting same value . could you please send formula ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Amit, i have donr like this -

    SUM(final[region_involvement_score])/100 still getting same value .
     
     
    Thanks,
    Raghu
  • 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.