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

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. 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Sansudhi8

 

Select 30 days % measure from FIELDS  pane and then go to modeling tab. 

In modeling tab you will see formatting section and  from there you can change decimal points.

 

 

Thanks & regards,

VivekC