Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
63 | |
51 | |
48 |
User | Count |
---|---|
211 | |
86 | |
64 | |
59 | |
56 |