Parameter not getting reset to default value when clicked on "clear selection"

[anmoltripathi5]

Hello,

I am facing an issue as follows in power bi.

I have created a Numeric range parameter with range -20 to 20, increment as 1, and default value as 0.

In slicer settings, under options I choose style as "Greater than or equal to".

When I select some value though the parameter and then click on clear selections, it gets reset to -20 instead of zero.

What should I do, so that whenever user puts some value to it and then click on clear selection, it should get reset to zero.

Please help me with a solution.

Thanks in advance 

[Anonymous]

Hi @anmoltripathi5 ,

You can try to set the slicer style to single value and then create measure to get the value greater than the slicer. You can refer to the following example:

Measure = 
IF(MAX('financials'[Manufacturing Price]) >= 'Parameter'[Parameter Value],MAX('financials'[Manufacturing Price]))

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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

[anmoltripathi5]

Hi @Anonymous , thanks for your response Originally my range is from -2000 to 2000, I took -20 to 20 as an example. Sorry about the confusion here. When I select single value as an option then maximum range Power BI allows us is of 1000 with increment of 1. Thats why I selected greater than equal to type, then I made bit change in my dax. Greater than equal to type provides me range more than 1000.

Is there any way I can keep my range from -2000 to 2000 still will be able to reset my default value to 0?

[Anonymous]

Hi @anmoltripathi5 ,

You can try using a custom visual mass filter.

After creating a numeric range parameter, put it into this visual object and it will filter out the values you want and when the filter is cleared, it will go back to the default value of 0.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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

[Shivu-2000]

Hi @anmoltripathi5 

The behavior you’re observing occurs because Power BI’s default behavior for clearing slicer selections resets to the minimum value of the slicer range when using range parameters. To make the slicer reset to a default value (like 0 in your case) instead of the minimum (-20), you need to employ a workaround since Power BI doesn't natively support this functionality.

Use this Dax:

Selected Value with Default =
IF(
ISFILTERED('YourTable'[Numeric Range Column]),
SELECTEDVALUE('YourTable'[Numeric Range Column]),
0
)

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

[anmoltripathi5]

Hi @Shivu-2000 , If possible can you please explain how and where I need to use this dax so that it gets link to the parameter to make the default value as 0