Dynamic Slicer Working

[Pradeep160]

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%

[miTutorials · Accepted 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.

Dynamic Segmentation: Identifying Top & Bottom N% Customers by Sales in Power BI | MiTutorials - You...

[Pradeep160]

Thank you @miTutorials. It worked. 

[Pragati11]

HI @Pradeep160 ,

Have you tried using what-if parameters in this case?