To use the drill mode, the Power BI visual must have an explicit or implicit hierarchy. Those hierarchies are marked with the hierarchy icon. A common date hierarchy is one that contains fields for the year, quarter, month, and day.
-
Created 3 card visuals containing the measures: Total Sightings, % in American Southwest, and % Suspected Hoax.
-
Created a column chart containing Total Sightings over Time
-
Created a matrix visual containing the Total Sightings by Location, Shape, and Duratio add +/- buttons to the row headers through the formatting pane under the Row headers card.
Find the number of Fireball shaped UFO sightings in June 2020 in Las Vegas, NV.