Inputted Text on PowerBi Dashboard

[Anonymous]

Hello,

I am currently working on building a Power BI dashboard where users can input a number (e.g., 25,000,000) and have it dynamically affect the measures in place. The goal is to create an interactive and updatable goal that reflects the user's input in real-time.

Here's what I'm trying to achieve:

1. User Input: Allow users to input a large number directly on the dashboard.
2. Dynamic Calculation: Use this input to perform calculations behind the scenes.
3. Real-Time Update: Display the calculated result in a visual, such as a graph or table, under a "Goals" column.

The challenge I'm facing is finding a suitable method to capture large numeric inputs and integrate them seamlessly into the existing measures. Any suggestions or best practices on how to achieve this in Power BI would be greatly appreciated.

[v-pnaroju-msft]

Hi evandom,

We are following up to check if your query has been resolved. If you have found a solution, kindly share it with the community to help others facing similar issues.

If our response was helpful, please mark it as the accepted solution. This will benefit the wider community.

Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Hi evandom,

We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.

Thank you.

[v-pnaroju-msft]

Hi evandom,

We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

Thank you.

[v-pnaroju-msft]

Thank you, @lbendlin ,@HiteshDataXpert, @Anonymous for your response.

Hi evandom,

We would like to check if the solution provided by @lbendlin, @HiteshDataXpert , @Anonymous  has resolved your issue. If you have found an alternative approach, we encourage you to share it with the community to assist others facing similar challenges.

If you found the response helpful, please mark it as the accepted solution and add kudos. This recognition benefits other members seeking solutions to similar queries.

Thank you.

[Anonymous]

Hi @Anonymous ,

Based on the information, what if parameter should be helpful. Besides, try to use dynamic M query parameters.

You can view the following links to learn more information.

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn

Use parameters to visualize variables - Power BI | Microsoft Learn

Solved: Develop a Dashboard with a User-input Form to Add ... - Microsoft Fabric Community

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HiteshDataXpert]

1. Create a Parameter for User Input

Power BI allows you to create parameters that users can interact with. Here's how to set it up:

• Go to the Modeling tab in Power BI Desktop.

• Click on New Parameter.

• In the Parameter window:

  • Set the Name (e.g., "User Input").

  • Choose Decimal Number or Whole Number as the data type (depending on your needs).

  • Set the Minimum, Maximum, and Increment values (e.g., 0 to 100,000,000 with an increment of 1).

  • Check the box for Add slicer to this page to allow users to input the value.

This will create a slicer on your report page where users can input or adjust the number.

---

2. Use the Parameter in Measures

Once the parameter is created, you can use it in your measures to perform dynamic calculations.

• Create a new measure or modify an existing one to incorporate the parameter.

• For example, if you want to calculate a percentage of the user input:

  DAX

  Dynamic Measure = [Your Existing Measure] * [User Input]

  Replace [Your Existing Measure] with the actual measure you want to dynamically adjust.

---

3. Display the Results in Visuals

Now that your measure is dynamically linked to the user input, you can use it in any visual (e.g., table, chart, or card).

• Drag the Dynamic Measure into a visual (e.g., a table or bar chart).

• Add a "Goals" column or visual to display the calculated results.

Also use What-If Parameters for Advanced Scenarios

If you need more advanced scenarios (e.g., multiple inputs or ranges), consider using What-If Parameters:

• Go to the Modeling tab and click on What-If Parameter.

• Set up the parameter with the desired range and increments.

• Use it in your measures and visuals similarly to the basic parameter.

[lbendlin]

You can use "What If?" parameters (Range parameters) as long as you keep the range to 1000 individual data points.

Or - use the Filter pane Advanced filtering option - there you can let the user enter arbitrary numbers.