Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
The mesaure value change will be according to the MyField,. So, for BLABLA Percentage % data in my Myfiled, I need display this value as " 25 % "
solution should be like:
TextMeasure = IF([MyField]="BLABLA Percentage %", < Something value like 25 %>, [AMOUNT])
Can I implement any workaround for this requirement ?
DAta Format is not availbale inside the IF block. Also Measure Formatting option can not be applied because all of the value fileds will be displayed as percentage then.
do you have any other opinion
Thank you
Solved! Go to Solution.
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 - you can also do this with dynamic formatting
Here is a tutorial:
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |