Single Value Slicer

[Anonymous]

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/

[Pragati11 · Accepted solution]

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

[Anonymous]

You my friend, are a genius. Thank you, not sure why I couldnt see the forest through the trees.

[Pragati11]

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