Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am working on a Power BI report that uses the Students data of a school. One of the key metrics that I have created is the attendance percentage, which is calculated as the ratio of total attended days to expected days of school attendance. I am showing the overall attendance of the students in a table visual with their roll number, name, and attendance percentage. I need to create a slicer that has different ranges of attendance percentages, such as <30%, <40%, <50%, <55%, <60%, <65%, <70%, and so on up to <100%. When I select a range from the slicer, for example <50%, I want to filter the table visual to display only those students whose attendance percentage is less than 50%. How can I achieve this functionality? Below is sample expected output.
Student ID | Student Name | Attendance % |
1 | John | 48% |
2 | Peter | 46% |
3 | Morgan | 41% |
Solved! Go to Solution.
You can achive this using What If Parameter, please see the below video from 7:40 onwards.
In the tutorial I have used the Cumulative % in the measure you can refer to your Attendance % column and follow rest of the steps.
You can achive this using What If Parameter, please see the below video from 7:40 onwards.
In the tutorial I have used the Cumulative % in the measure you can refer to your Attendance % column and follow rest of the steps.