Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have a dashboard I am trying to create with the ability to move sliders to show what would give us a normal distribution of our Field Intelligence Score.
The Field Intelligence Score is a calculated Column that is =
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 !!
Hello, thanks for the quick response. I followed the steps and don't quite have it working so I have a few question that I was not clear on and maybe that is why.
First, creating the measures: "```DAX
Adjusted Risk Level = [Selected Risk Level] * 0.5
```
```DAX
Adjusted Assessment of Compliance Score = [Selected Assessment of Compliance Score] * 0.5"
These were calculated columns and so the measure would not let me use calculated columns. I altered the formula to have SELECTEDVALUE( before your formula. Was this wrong? I did this.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |