title: Summarizing and Rank in Power BI
body: <p>I hav a set of data with the following columns:    Date, Teacher_Name, Class, Student_Name, Attendance.</p>
  <p>Attendance parameter:
  2-Full attendance
  1-Leave half way
  0-No show</p>
  <p>I would like to have a visual with the following:</p>
  <p>Top 5 students with most &quot;No show&quot; for latest 3 consecutive weeks by Teacher</p>
  <p>Week grouped by Sat-Fri</p>
  <p>Please advise on how I can do this in Power BI</p>