Two Ways to Create Single Value Input Slicers in Power BI!

[@redlegcraig]

This was very helpful as I was recreating an existing report that had a single value input field. At first I just copied the DAX that created the table, so I didn't have the Single Value option when formatting my slicer. This video showed how to insert a table as a what if parameter. Thanks!

[@datamandy8975]

Well explained!

[@AdolfoHernandez-q4p]

Great video! Do you have to buy a license of Tabular Editor 3 to apply this solution?

[@HavensConsulting]

You could do this in TE2 (free) as well :)

[@ashleyg4546]

I saw someone in the comments ask the same question but did not get a response. So how did you create the input field on 4:08?

[@HavensConsulting]

As the video continues it'll show you that it's a (single value) slicer type, which is normally associated with a numeric range field parameter. I then show the SQLBI article that inspired me, then I open tabular editor to show the settings to change per that video, and the rest of the video is the tutorial on that.

[@samuelkrall9306]

Great video, implemented. easily in one of my reports. Also what type of visual is that multi-dimensional pie chart???

[@HavensConsulting]

Chord Visual :) appsource.microsoft.com/en-us/product/power-bi-visuals/wa104380761?tab=overview

[@samuelkrall9306]

@@HavensConsulting thank you, i think the folks upstairs are going to like this one...

[@havenscr]

@@samuelkrall9306 happy to help!

[@NirdeshM]

i am looking for input field from where user can supply the value, is this same?

[@HavensConsulting]

Not sure I'm following the entire question. Could you elaborate a bit?

[@premcst]

Show me some one who can explain it better !!