cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Swinden
Frequent Visitor

Text Box That Interacts with dataset

Hello,

 

I believe i know the answer to this already, but has anyone successfully used a variable text box so that a user can input a multiplier and have the data below interact with the user input?

 

Example would be, Lets say you have a use case where you want to figure out how many units to sell to cover X number of weeks of forecast.  So end user could say "I want to sell customer 10 weeks of sales" and input "10" into a text box, and have the visual below multiple by that many.  Here is an example in excel;

 

User is saying they want to sell 10 weeks of inventory for every customer below.  A simple recommendation is spit out below

 

Swinden_0-1632246634153.png

 

3 REPLIES 3
Raptor
Helper I
Helper I

@Swinden: I think there even was a useful video from "Guy in a Cube" on Youtube about this mattern. Unfortunately, I do not have the time to find it right now. In case I find it later on, I will update my post.

V-lianl-msft
Community Support
Community Support

Refer to what @amitchandak  said, and then create a measure:

Measure = AVERAGE('Table'[AVG])*Parameter[Parameter Value]

 

amitchandak
Super User
Super User

@Swinden , I think you need to use what if parameter

 

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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors