The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
142 | |
109 | |
107 | |
74 | |
61 |
User | Count |
---|---|
266 | |
127 | |
119 | |
100 | |
88 |