Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
etills
Frequent Visitor

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

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?

2 REPLIES 2
123abc
Community Champion
Community Champion

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:

  1. 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.
  2. 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.
  1. 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.
  2. Use the Calculated Columns/Measures in the Table Matrix:

    • Build your table matrix and use the calculated columns or measures in the appropriate places.
  3. Create Relationships:

    • If needed, create relationships between tables to ensure proper filtering.
  4. Add the Parameter Slider to the Report:

    • Add the parameter slider to your report.
    • Use the "WeightParameter" in your calculations.
  5. 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.

123abc
Community Champion
Community Champion

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:

  1. 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.
  2. 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.
  1. 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.
  2. Use the Calculated Columns/Measures in the Table Matrix:

    • Build your table matrix and use the calculated columns or measures in the appropriate places.
  3. Create Relationships:

    • If needed, create relationships between tables to ensure proper filtering.
  4. Add the Parameter Slider to the Report:

    • Add the parameter slider to your report.
    • Use the "WeightParameter" in your calculations.
  5. 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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.