cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

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

1 ACCEPTED SOLUTION

Accepted Solutions

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

 

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)
1 REPLY 1

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

 

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)