Strange behavior in What if Parameter "%"

[prakash11440278]

HI All,

I am seeing strange behavior in what if parameter where i am entering the data the value expects to add in decimal where come out of the parameter it is displaying in whole number %. Expression i am using to generate is as below and converted the expression to "%". My requirement is it enter the data in percentage.

Expression: Parameter = GENERATESERIES(CURRENCY(0), CURRENCY(1.01), CURRENCY(0.01))

While Entering the data in the cell:

When comout of the report:

[v-robertq-msft]

Hi, @prakash11440278 

As far as I’m concerned, the data type you can enter into the What-if slicer is based on the data type selection you selected when created the What-if Parameter. And as you can see, there is no selection for the “Percentage”, so the Power BI doesn’t support you to enter the percentage type into the What-if slicer.

You can only change the format of the parameter value like this:

More info about the What-if Parameter.

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.