Drill Through, Drillup/Drilldown And Tooltip

Power BI 

Drill Through :

Steps :

→ Create a new sheet, and add a Pie chart 

Ex : Count of the population by country

→ Now, create another sheet, and then add a simple table with 

Country, state, and count of the population 

→  Add country to the drill through the filter area of the table. Disable the Keep-all option for now.

→ Go back to the sheet with the pie chart and right-click any area, and then click on Drill through.

Drillup/Drilldown :

Steps:

→ Create a new sheet, and create a new hierarchy by left click on any column

→ Now, Select any columns and add them to the hierarchy and use hierarchy in visualizations 

Ex : Create a hierarchy on the country column (Hierarchy Name: Country_hir)

       Add State column to Country_hir 

       Add District column to Country_hir

Tooltip : 

Steps:

Create a new page in the Power BI Dashboard 

Goto Page Properties. Select Page size as Tooltip

Add a couple of visualizations. Ex: sales by cost

Goto View → Page View → select Actual Size 

In the page properties(Page Information), enable the tooltip.

In the tooltip properties, drag and drop the Sales column.

Go back to the main dashboard, wherever you see the Sales column, the tooltip will be available.