Forum Discussion

SLI's avatar
SLI
Helper IV
7 years ago
Solved

% in measure

Hello   how can i do to display the % in a calculated measure of power bi   My calculated measure= DIVIDE(sum(BI_facture[montant]);SUM(BI_devis[montant du devis]))*100   Thanks in advance   S...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi SLI

     

    Just concatenate % with your measure.

     

    My calculated measure= DIVIDE(sum(BI_facture[montant]);SUM(BI_devis[montant du devis]))*100&"%"

     

    Regards,

    Vivek 

     

     

  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi SLI,

    Based on my test, you could refer to VivekC's solution and you could also set the format in 'Modeling':

    Regards,

    Daniel He

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi SLI

 

Just concatenate % with your measure.

 

My calculated measure= DIVIDE(sum(BI_facture[montant]);SUM(BI_devis[montant du devis]))*100&"%"

 

Regards,

Vivek 

 

 

  • Sansudhi8's avatar
    Sansudhi8
    Helper III
    7 years ago

    Dear ViveKC,

     

    Could you please let me know how to change format to 2 decemail point of percentage. 

     

    Please see my below example.

     

    Thank you

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Sansudhi8

       

      Select that column that you have have change upto 2 decimal points

      and under the Modeling tab click on formatting section.

       

      find below snaps for more clarification 

       

       

      Regards,

      Vivek 

      • Sansudhi8's avatar
        Sansudhi8
        Helper III
        7 years ago

        Dear Anonymous,

         

        I just need to change format of precentage. I don't have a column for it. i just insert your formular. 

         

        Could you please help me.