Using Sliders to Show Normal Distibution in Graph

Anonymous 

To achieve dynamic visualization updates based on slider inputs in Power BI, you can use a combination of slicers, measures, and a line chart. Here's a step-by-step guide:

1. **Create Slicer for Risk Level and Assessment of Compliance Score**:
Create slicers for Risk Level and Assessment of Compliance Score. These slicers will allow users to adjust the percentage values for each component.

2. **Create Measures for Adjusted Field Intelligence Score**:
Create measures for the adjusted Field Intelligence Score based on the selected values from the slicers. For example:

```DAX
Adjusted Risk Level = [Selected Risk Level] * 0.5
```

```DAX
Adjusted Assessment of Compliance Score = [Selected Assessment of Compliance Score] * 0.5
```

Then, create a measure for the adjusted Field Intelligence Score:

```DAX
Adjusted Field Intelligence Score = [Adjusted Risk Level] + [Adjusted Assessment of Compliance Score]
```

3. **Create Line Chart for Normal Distribution**:
Create a line chart visual with the date on the x-axis and the Adjusted Field Intelligence Score on the y-axis. This will show the normal distribution of the Field Intelligence Score over time.

4. **Interact with Slicers**:
Configure the line chart to interact with the slicers. Set the visual-level filters for Risk Level and Assessment of Compliance Score to use the adjusted measures created in step 2.

5. **Testing and Adjustments**:
Test the functionality by adjusting the values in the slicers and observing how the line chart updates accordingly. Make adjustments as needed to ensure the visualization behaves as expected.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!