Forum Discussion

aakgun's avatar
aakgun
Frequent Visitor
10 years ago
Solved

Dynamic Formatting Measure numerical values

I need a workaround for my Measure values. I have percentage and decimal values for my meaure. For percentage ones, I need to display it as formatting "25 % " not like 0.25 or anythig like that.   ...
General Comment
  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    aakgun

    If your scenario is not as I thought in below case, please be more specific.

    Measure = IF(LASTNONBLANK(Table1[MyField],1)="BLABLA Percentage %",AVERAGE(Table1[value])*100&"%",SUM(Table1[value])&"")


Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

aakgun

If your scenario is not as I thought in below case, please be more specific.

Measure = IF(LASTNONBLANK(Table1[MyField],1)="BLABLA Percentage %",AVERAGE(Table1[value])*100&"%",SUM(Table1[value])&"")


aakgun's avatar
aakgun
Frequent Visitor
10 years ago

Hi Eric,

 

Thank you for that workaround. I have displayed as I desired. Just I had a small modification for formatting numerical values.

 

I have used following formatting, and now dispay excellent for my PErcentage labelled values..

 

FORMAT(AVERAGE(tableName[VALUEKolon] ) * 100 , "###,###.##") & " %"

 

Thanks so much

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    aakgun were you able to dynamically format numbers?

     

    I have similar challenge I have KPI columns with some % and some decimals. based on KPI name i have to format KPI_NUM column. Can you please help?

     

    Thank you