How to create single number search box slicer to compare with matrix totals

[V_Ramugade]

Hi All,

I am working on the power bi report where I need below mention requirements.

I need a single value search numeric slicer box where user can put any number to compare it with matrix visual totals.

I had used the Parameter with numeric range and it's working but not completely as expected. with this approach when I put the value 10 into the search box slicer then it filter matrix and provide correct results. but when I put 11 into the search box slicer then my sclier value get change back to 10 and it work as a looking for 10 only instead of 11.

While searching for this issue then I came to know this is because of incremental behaviour of the parameter table field. So, if you put any old number into the slicer box then it reduced by 1 and if you put any even number then it doesn't impact on that search numbers.

So, I want a slicer to accept any free number input from user into the search box slicer without changing the actual inputed number and compare that number only with matrix totals.

Below are the screen shot for the reference. 

Thanks.

[v-pgoloju]

Hi @V_Ramugade,

Just a gentle reminder — has your issue been resolved? If so, we’d be grateful if you could mark the solution that worked as Accepted Solution, or feel free to share your own if you found a different fix.

This not only closes the loop on your query but also helps others in the community solve similar issues faster.

Thank you for your time and feedback!

Best,

Prasanna Kumar

[v-pgoloju]

Hi @V_Ramugade,

We wanted to kindly check in to see if everything is working as expected after trying the suggested solution. If there’s anything else we can assist with, please don’t hesitate to ask.

If the issue is resolved, we’d appreciate it if you could mark the helpful reply as Accepted Solution — it helps others who might face a similar issue.

Warm regards,

Prasanna Kumar

[v-pgoloju]

Hi @V_Ramugade,

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.

If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,

Prasanna Kumar

[danextian]

Hi @V_Ramugade 

While searching for this issue then I came to know this is because of incremental behaviour of the parameter table field. So, if you put any old number into the slicer box then it reduced by 1 and if you put any even number then it doesn't impact on that search numbers.

This may be true if you have a wide range of numbers in your numeric parameter or the increment is in decimals but between 10 and 11,  you should be able to input 11 successfully assuming that the upper limit of your numeric parameter is 11 or higher.

As what @Deku has mentioned, make sure that your numeric parameter table covers are all the values you want as an input.  In the screenshot below, you can only input numbers 1 through 20, no more, no less and definitely no decimals.

[V_Ramugade]

Hi @danextian & @Deku,

I have provided you the sample version of the report. But in my actual report, user can put any number as per his/her desire right. So, for that pupose I had selected the range from 0, 2000 into the parameter column for generateseries. not sure is there any other way where we can provide a free number search slicer box for user to input his desire number and compare the same with matrix subtotals to see correct data.

Please provide your feedback on the same.

[danextian · Accepted solution]

Hi @V_Ramugade 

Inputting a number beyond what's in the model is currently not supported. What you're asking for is kind of a writeback feature which isn't natively supported. There are custom visuals that can do that but they do come with a price -  a hefty price.

[Deku]

You need to expand your price over value to cover the range of values you want to allow uses to enter

Generateseries(0, X, 1)

So increase X to the required value

You can't take any arbitrary value from a slicer

[V_Ramugade]

Thanks for the reply @Deku. But they what will be the possible solution for the same?

[Deku]

In your measure you are also using < you need to use <=

[V_Ramugade]

No, I used only >. And that is my report requirement. Hope you are going with all my post content thoroughly ?

[Deku]

I reread again. Mistep on your 10 11 but. Think you only need to expand the range of your selection table