Skip to content

Ravi Sir's Cards › Power BI

16. Drill Up and Drill Down: Cards

मराठी cards · Open the chapter

Revision cards

Prepare the hierarchies. Drilling only works when the levels are in the right order. — Revision card 1 of 6: Prepare the hierarchies · Download PNG · Open card page

Lesson: 16.1 Prepare the Hierarchies

The drill buttons. Users need to move from the big picture to detail and back. — Revision card 2 of 6: The drill buttons · Download PNG · Open card page

Lesson: 16.2 The Drill Buttons

Drill down vs expand. The buttons look alike but give different results. — Revision card 3 of 6: Drill down vs expand · Download PNG · Open card page

Lesson: 16.3 Drill Down vs Expand – the Difference

Matrix expand, collapse and icons. A matrix with many levels is too long if every row is open. — Revision card 4 of 6: Matrix expand, collapse and icons · Download PNG · Open card page

Lesson: 16.4 Matrix: Expand, Collapse and +/- Icons

Include and exclude. Sometimes one data point should be hidden or shown alone in one visual. — Revision card 5 of 6: Include and exclude · Download PNG · Open card page

Lesson: 16.5 Include and Exclude

Tips for drill-friendly reports. Users miss drill features if they do not know about them. — Revision card 6 of 6: Tips for drill-friendly reports · Download PNG · Open card page

Lesson: 16.6 Tips for Drill-friendly Reports

Interview cards

What is the difference between drill down and expand? Drill down goes into one selected item and shows only its children. Expand all down one level shows the next level for all items and keeps the parent level label. — Interview card 1 of 1: What is the difference between drill down and expand? · Download PNG · Open card page

Lesson: 16.3 Drill Down vs Expand – the Difference

Comparison cards

Go to next level vs Expand all down one level. Both show all items at the next level of a hierarchy. — Comparison card 1 of 1: Go to next level vs Expand all down one level · Download PNG · Open card page

Lesson: 16.3 Drill Down vs Expand – the Difference