Slicer in What-if parameter

[admin_xlsior]

Hi guys,

How is the setting of the slicers in What-if parameters ?

Because I have table that contain -1 to 1 and I want to have the same slicer, but what I got now is always two numeric input

This is from What-if feature:

And this is the one I created

[amitchandak]

@admin_xlsior , With a small down arrow , check what type of slicer it is. To me it seems a single value slicer.

[admin_xlsior]

Hi @amitchandak 

O yeah, it has addition option

But where does it come from ? Because I tried to copy this visual and change to my parameter table-field, and the option "Single value" is gone.

Thanks

[amitchandak]

@admin_xlsior , I doubt it was not there for decimal. But tried to add it for decimal and it worked. I am able to add a new decimal one with a single value

Create a new one and check

[admin_xlsior]

Yeah, I tried as well, by create new parameter, data type decimal from -1 to 1 increment 0.1. It works and has Single value option.

The only different is the field coming from GENERATESERIES function, while mine is a table field with type decimal number.

I still don;t why and how to obtain that. Meanwhile I'm using 'greater than' and for selected value measure using MIN().

But appreciate if there is an answer to my confusion.

Thanks

[amitchandak]

@admin_xlsior , I checked, this option manually generated series do not have an option

[admin_xlsior]

oo wow.. that is even worse 😅 

So its mean the option really only appear if using What-if procedural ?

[v-jingzhang]

Hi @admin_xlsior I found when I created a slicer and selected the parameter column from parameter table (which is generated by what-if parameter) and it also has the single value option.

[admin_xlsior]

hi @v-jingzhang ,

Yes, I know, but I need my table "not" from generated by what-if, since I'm using Direct Query

Thanks