Replacing Lower Values in report with asterisk (*) based on a threshold value

[Anonymous]

Hi All,

I am having a scenario which requires to replace the values in the report based on the following condition.

If the value falls below 10 then replace it with an asterisk (*).

 Thanks

[SteveCampbell · Accepted solution]

It is a bit hard to answer without much information. How is the data calculated etc? You could provide some examples.

With the information avaiable, you can try the measure:

New Value = 
var _old = SELECTEDVALUE(Table1[Old Value])
RETURN
if(_old<10, "*", _old)