% in measure

[SLI]

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

Sabrina 

[Anonymous · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

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]

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]

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]

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]

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