Forum Discussion
Single Value Slicer
Hi All,
I've searched far and wide for the ability to add a single value slicer to my report. The good news is I found one, I was able to retrieve a copy of a report showing exactly what I was looking for. The report I saw posted at PowerPivotPro showed a single value slicer that utilized the function "Generateseries=(start,end,interval)" upon attempting to add this to my report I was not able to achieve the same results. I noticed an icon I have not seen, it was a table with a question mark. I have a table containing a container count and am attempting to use a slicer to influence other items within the page. I would like it to be a single value entry either slider, or enterable field so users can update to the exact amount of containers. Unfortunately, unlike the report I am attempting to sample, was only able to have either a vertical slicer with tiles, or a ranged slicer.
If anyone is able to assist I would appreciate it.
Link to report sampled
https://powerpivotpro.com/2018/02/using-selectedvalues-capture-power-bi-slicer-selections/
Hi Anonymous ,
Have you tried using a What-If parameter rather than a slicer? For details you can see the following link:
https://docs.microsoft.com/en-us/power-bi/desktop-what-if
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
3 Replies
- Pragati11Super User
Hi Anonymous ,
Have you tried using a What-If parameter rather than a slicer? For details you can see the following link:
https://docs.microsoft.com/en-us/power-bi/desktop-what-if
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
- AnonymousNot applicable
You my friend, are a genius. Thank you, not sure why I couldnt see the forest through the trees.
- Pragati11Super User
HI Anonymous ,
I can understand the feeling you have right now. I am quite used to this on daily-basis.
Just Keep Learning!
Thanks,
Pragati