Power BI - Slicer

The Slicer worksheet is the most effective tool available to do ad-hoc queries without designing your own workbook.

There are four user selectable fields available to do a drilldown hierarchy, and over 30 measure fields to summarize.