topic Re: Can I have a slider in the report view change data in the Table view in DAX Commands and Tips

Can I have a slider in the report view change data in the Table view

Anonymous — Wed, 13 Dec 2023 03:28:56 GMT

Hello,

I am working on a visual report for my Power Bi project, where I have a table matrix with numerous columns in it. I want to make sliders that works a weigh metric that changes the values in these columns. These columns are made up of the following.

Column A,

Standardized Column A

Column B

Standardized Column B

Column C

Standardized Column C

Relative Column ABC

Ranking of Relative Columns ABC

My goal is to have a slider that adds a calculated weight to columns A,B,C and by changing the weight on this slider, this causes a trickle down effect where it changes the Standardized Column A,B, and C, Relative Columns ABC, and the Ranking of the Relative Columns ABC.

The goal is to have these values change on the table the matrix, which serves as a filter for all other visuals on the panel.

I have been able to create a parameter that works for changing the values in column on the table matrix, however I am unable to get this to have the trickle down effect.

Has anyone ever created a slider that works like this?

Re: Can I have a slider in the report view change data in the Table view

123abc — Wed, 13 Dec 2023 06:33:59 GMT

Yes, you can achieve this in Power BI by creating a parameter and using it in calculated columns or measures that are then used in your table matrix. Here's a general outline of how you can set this up:

Create a Parameter:
- Go to the "Home" tab in Power BI Desktop.
- Click on "New Source" and select "Parameter."
- Define your parameter with a name (e.g., WeightParameter) and set the data type to Decimal.
- Define the minimum, maximum, and default values for your parameter.
Create Calculated Columns or Measures:
- For each column that you want to be affected by the slider, create calculated columns or measures that use the parameter.
- For example, if you have a column A, create a calculated column like this:

Standardized_Column_A = YourTable[Column_A] * YourParameter[WeightParameter]

- Repeat this for other columns.
Create a Hierarchy or Dependency:
- Ensure that your columns are organized in a way that reflects the dependency. For example, Standardized columns depend on the original columns, and Relative Columns depend on Standardized columns.
Use the Calculated Columns/Measures in the Table Matrix:
- Build your table matrix and use the calculated columns or measures in the appropriate places.
Create Relationships:
- If needed, create relationships between tables to ensure proper filtering.
Add the Parameter Slider to the Report:
- Add the parameter slider to your report.
- Use the "WeightParameter" in your calculations.
Test the Slider:
- Test the slider by adjusting the parameter value and observe the trickle-down effect on your table matrix.

Make sure that you have a clear understanding of your data model and the relationships between tables. If your calculations involve complex logic, you might need to write more sophisticated DAX expressions.

Additionally, Power BI's community forums and documentation are valuable resources where you can find examples and ask specific questions related to your scenario.

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

In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.

Re: Can I have a slider in the report view change data in the Table view

123abc — Wed, 13 Dec 2023 06:34:00 GMT

Create a Parameter:
- Go to the "Home" tab in Power BI Desktop.
- Click on "New Source" and select "Parameter."
- Define your parameter with a name (e.g., WeightParameter) and set the data type to Decimal.
- Define the minimum, maximum, and default values for your parameter.
Create Calculated Columns or Measures:
- For each column that you want to be affected by the slider, create calculated columns or measures that use the parameter.
- For example, if you have a column A, create a calculated column like this:

Standardized_Column_A = YourTable[Column_A] * YourParameter[WeightParameter]

- Repeat this for other columns.
Create a Hierarchy or Dependency:
- Ensure that your columns are organized in a way that reflects the dependency. For example, Standardized columns depend on the original columns, and Relative Columns depend on Standardized columns.
Use the Calculated Columns/Measures in the Table Matrix:
- Build your table matrix and use the calculated columns or measures in the appropriate places.
Create Relationships:
- If needed, create relationships between tables to ensure proper filtering.
Add the Parameter Slider to the Report:
- Add the parameter slider to your report.
- Use the "WeightParameter" in your calculations.
Test the Slider:
- Test the slider by adjusting the parameter value and observe the trickle-down effect on your table matrix.

Additionally, Power BI's community forums and documentation are valuable resources where you can find examples and ask specific questions related to your scenario.

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

In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.