POWER BI- Drillthrough And Tooltip

DRILLTHROUGH IN POWER BI:-

• Drillthrough focuses on getting page details.
• By using Drillthrough, We can go to the one page to another page.
• EXAMPLE:-
• When I click on the visualization component it goes to another page i.e. Report Page to Data Page.

REPORT PAGE

DATA PAGE

• First, we add column names in drill through.

DRILLTHROUGH OPTION ON DATA PAGE

• Then automatically creates a button i.e. Back button.
• When we CTRL + Click on button then go back to the previous page.

BACK BUTTON

• Also, we can right-click on the visualization component. Goto Drillthrough option and select the page which wants to show. i.e. Data Page.

SELECT DRILLTHROUGH OPTION ON REPORT PAGE

• After that opens the Data page.

RESULT

TOOLTIP IN POWER BI:-

• When I hover the mouse on the visualization component then show the detail.
• First, add the page by clicking the + button and that page.

ADD NEW PAGE

• I will refer to the Data page.

DATA PAGE

• On Data Page, Goto Format → Page size →Type.
• Select the Tooltip option.

FORMAT OPTION

• Then Goto view tab, Click on page view and select the Actual Size.

VIEW TAB

• Tooltip option enables in Page Information.

PAGE INFORMATION

• After that select the visualization component and go to the Format option.
• The format option enables the tooltip option as well as selects the Type and Page.

• Goto Data Page → Field → Then select Tooltip which is required for page.

FIELD OPTION

• Then go to the main page which will the hover mouse and shows the detail.

REPORT PAGE

• On the Report page, Goto Format option → Enable the Tooltip
• In Tooltip dropdown menu for Type and Page.
• Select Type is a Report page and Page is Data Page.

FORMAT OPTION ON REPORT PAGE

• The field option automatically gets the Data page.

• After that, When I hover the mouse on the visualization component then show the detail.

RESULT

If you are new to Power BI start with the following must-watch video: -