Forum Discussion
Single value option with Slicer
Hi everyone,
I'm following a model example and I noticed that its slicer has an option called 'Single Value':
I want to know how to get this option because in my model I just get the others options:
I have also checked Numeric Range Slicer from Preview features, in both cases data type are Whole number, the only difference is the symbol type
Thank you very much for the help!
- The column in your example seems to be a What If parameter (see here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2017-feature-summary/#analytics).
That may cause the slicer to behave differently.
6 Replies
- lndnbrgResolver IIIThe column in your example seems to be a What If parameter (see here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2017-feature-summary/#analytics).
That may cause the slicer to behave differently.- joseabarrigaFrequent Visitor
I had the same issue and it works for me. Thanks lndnbrg
- Gopal4416Frequent Visitor
Without using what if parameter can i get single value in slicer (my Model Image)
- ShaWoAdvocate I
I'd be interested in this too.
Based on my experiments it seems that the single value slider is only available through what if parameter creation. Even if I create new table with similar generateseries dax that I have in a what if parameter the single value slider isn't available. Has anybody figured out if I can assing a new table as a parameter table or if there is any other way to get the single value slider?
- Gopal4416Frequent Visitor
If that is possible to have single value slicer without using what if parameter.
I mean Slicer value in angle from my model (image).