User Input in slicer should be 40 instead of 0.04 (in Percentage)

[Shifty1993]

Dear community,

I created a table:

IN_rate = GENERATESERIES(0, 0.5, 0.001)

I changed the data type: Decimal Number

I changed the format: Percentage

I created a slicer which allows a manual user input.

The problem is that the user has to type in 0.40 to get his 40 %.

I want him to type in 40 to get his 40 %.

Somehow I am not able to fix this problem.

Thank you for help in advance.

Best regards,

Phil

[Shifty1993 · Accepted solution]

This is not what i actually meant. But i could solve it.

I changed to modell view and changed the value to whole number.

Then I could switch the format to custom.

Afterwards switch the value to decimal number. (where you cannot find the format "custom").

In the custom settings put a string " %".

Now the user input should be for 40  => 40 %.

Afterwards create a measure which takes the value in the input and divide it with 100.

Result: User types in 40 and receives in his view 40 %, but the system receives 0.4 for further calcs.

Topic solved.

[amitchandak]

@Shifty1993 , As this a % column (based on what I got)  it will show .4 as 40% but have value .4

So can multiply the measure by 100

selectvalues(IN_rate[value]) *100