Is this possible? A graph/slider where you input a number/value and get an output.

[sharpedogs]

For example, we have a print service. For every impression it costs $0.05. Lets say Julie did 1,000 impressions in 2019, her print bill would have been $50..

I want to add something to my dashboard that would allow me to show Julie if she reduced her Print by 200 impressions she would save $10. I'm not sure how to encorporate this sort of graph/slider?

My table of data is as such. The unit price is not in the table, it's a DAX (Number of Impressions X ($0.05))

User	Mono Impressions	Color Impressions
Julie	500	500
Chad	1000	150
Jeff	250	300

[Greg_Deckler · Accepted solution]

Sounds like you want a What If parameter. Basically it is a table created using GENERATESERIES coupled with a measure that uses SELECTEDVALUE. Found in the What If area of the Modeling tab of the ribbon and is now called New parameter

[Greg_Deckler · Accepted solution]

Sounds like you want a What If parameter. Basically it is a table created using GENERATESERIES coupled with a measure that uses SELECTEDVALUE. Found in the What If area of the Modeling tab of the ribbon and is now called New parameter

[sharpedogs]

the What If statement.... where have you been all my life :)...

[sharpedogs]

Hey Greg, 

by the sounds of it, yes that is what i am looking to accomplish. But my skillset is not yet there with respect to creating it. I'm reading two books at the moment (one of DAX and one on visualizations). Parameters havn't yet come up, is there by any chance a Youtube video you can recomend? 

I'll also take a look today on YouTube for parameters. I didn't understand prior to your comment how that would have helped me. 

[Pragati11 · Accepted solution]

Hi @sharpedogs ,

You can refer following link to create What-If Parameters in Power BI:

https://docs.microsoft.com/en-us/power-bi/desktop-what-if

Thanks,

Pragati