Forum Discussion
Manual data input by the user
HI Anonymous
1. Create a new "What If" parameter under the Modeling Tab:
Clicking this button will bring up a new window with several input options.
2. Enter the range of numbers and the number of steps in between:
Name: This is the name of your parameter (input variable).
Data Type: This defines the type of variable. Whole number, Decimal number or Fixed decimal number.
Minimum & Maximum: These are the starting and ending numbers for your variable (think of it like a range of valid inputs).
Increment: This represents the increment between your minimum and maximum values. This will affect how many values can be selected as an input.
After you have your range of numbers (values entered for Minimum, Maximum) and the increment, click OK and Power BI will insert a new table for you in your DAX model. This is your table of valid input options for your users.
Anonymous
What about powerapps form like a box, and this value will go to sharepoint or azure data base and then will be updated back to powerbi and will be used in DAX.
Hi Anonymous
In your intial ask I believe live connection is not mentioned.
You are right, with live connection/streaming dataset you can't create a parameter or table as there is no M query involved.
HI Anonymous
1. Create a new "What If" parameter under the Modeling Tab:
Clicking this button will bring up a new window with several input options.
2. Enter the range of numbers and the number of steps in between:
Name: This is the name of your parameter (input variable).
Data Type: This defines the type of variable. Whole number, Decimal number or Fixed decimal number.
Minimum & Maximum: These are the starting and ending numbers for your variable (think of it like a range of valid inputs).
Increment: This represents the increment between your minimum and maximum values. This will affect how many values can be selected as an input.
After you have your range of numbers (values entered for Minimum, Maximum) and the increment, click OK and Power BI will insert a new table for you in your DAX model. This is your table of valid input options for your users.
Thanks, this is precisely what I was looking for! 🙂
I've checked this works in a PBI in which I imported data from a database.
I've tried to do the same in a PBI whith a live connection to a cube (Get Data -> SQL Service Analysys Services database -> Connect live) but the "New parameter" button is inactive there. Can you figure out any alternative to get an input from the user in that scenario? If not, I could solve it somehow by adding a new table with a wide range of values and then putting a slicer on the report, but I don't see a way to create a table either.