DrillThrough in PowerBI

Problem statement

Drill Through of Category and Region based on sales.

High level resolution steps

I have to Drill down Sales by Category and Sales by Region using Drill Through property.

Detailed resolution steps
Step 1:-

In PowerBI “MainPage” I have two visual representations based on Category and Region.
In First Visual I used Clustered Bar Chart and shown the Sales by Category. And in Second visual I used Pie Chart and shown Sales by Region.
And to apply drill through select button i.e. Insert >> Button >> Right Arrow.

Step 2:- Now add ByCategory sheet, in that I want to show sub-Category sales, year sales and segment sales based on individual category using Drill Through. And in ByRegion sheet, I want to show customer name sales and city sales based on region.

ByCategory Sheet :-

ByRegion Sheet :

Step 3:– Now in “Main Page”, Add action in both the button. For that first select the button and in Format button pane enable Action option. After that, expand the Action option and select Type as Drill Through and Destination as ByCategory for Sales by Category visual. For Sales by Region change Destination as ByRegion.

Output:
Drill Through in PowerBI.webm

/* H1 style */ h1 { font-size: 24px; /* Adjust the size as needed */ font-weight: normal; /* You can use 'bold', 'lighter', 'bolder', or a number */ } /* H2 style */ h2 { font-size: 20px; /* Adjust the size as needed */ font-weight: normal; /* Adjust the weight as needed */ } /* H3 style */ h3 { font-size: 18px; /* Adjust the size as needed */ font-weight: normal; /* Adjust the weight as needed */ }