The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 |
---|---|
69 | |
69 | |
66 | |
54 | |
28 |
User | Count |
---|---|
112 | |
82 | |
66 | |
48 | |
43 |