Inputted Text on PowerBi Dashboard

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.