Forum Discussion

Pradeep160's avatar
Pradeep160
Frequent Visitor
2 years ago
Solved

Dynamic Slicer Working

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 IDStudent NameAttendance %
  1John48%
2Peter46%
3Morgan41%
   

3 Replies