Forum Discussion
Dynamic Formatting Measure numerical values
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])&"")
Hi all,
I want to some more clarify about problem.
Can we use text data as measure in Data Field of MAtrix objects. I want to display my data with "% " sign as text value, according to the data rows. So it is a kind of conditional display.
I see in forums that there is a custom measure like " text measure" , but I could not implement it in Power BI desktop.
Dou you have any workaround or opinion for this issue.
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])&"")
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
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