Скачать или смотреть ExcelR Assignment Solution for BA and Data Analytics. Q7 Donut Chart with Drill Through in Power BI

In this Power BI tutorial, learn how to create an interactive Donut Chart showing Region-wise Profit using the Superstore Dataset, and enable Drill Through to a detailed report page filtered for the West Region.

🔍 Topics Covered:

Creating a Donut Chart in Power BI

Region-wise Profit Visualization

Setting up Drill Through functionality

Navigating from summary to detailed report view

Best practices for interactive dashboards

📊 Dataset Used: Sample Superstore Dataset

💡 Ideal for: Power BI Beginners, Data Analysts, Business Intelligence Enthusiasts

👉 Don't forget to Like, Share & Subscribe for more Power BI tutorials!

------------------------------------------------------------------------------------------------------------------_____


This is an ExcelR assignments

Q1. Power BI Platform
What is PowerBI and What are the various Platforms of Power BI?

Q2. Dax
Create a line and clustered column chart and compare this year vs last year's sales along with growth % using DAX? Refer superstore dataset

Q3. Data Modeling
Import data from 2023 Worldwide Box Office - Box Office Mojo and add the past 3 years of data in the Power Query editor, create a master table of the past 3 years of data, and load only master data in the Power BI query editor or Power BI desktop?

Q4. Waterfall chart
Create the Waterfall Chart to show Category-wise, Yearly Analysis using Superstore Dataset.

Q5. Hierarchy: -

Create the Hierchey and rename with Location for Country-State-Region-City -Postal Code and Show the Location wise Sales using Superstore Dataset

Q7. Drill through
Create Donut Chart to Show region wise Profit and Drill through the other page with West Region using Superstore Dataset



Data Load from website
Create Donut Chart in PowerBi
Drill Through Region Wise in PowerBi
how to create Dashboards, in PowerBI,

how to create Navigation in PowerBI,

how to create Bookmark in PowerBI

how to create slicers in PowerBI,

how to create charts in PowerBI

how to add cards in PowerBI

how to make page navigation in PowerBI


best youtube channel is Vikas Educlass

best excel channel is Vikas EduClass

Vikas Educlass

learn Microsoft excel in hindi free

learn Excel with Vikas Educlass

🟢 1. Introduction
"Hello friends! In today's video, we’ll learn how to create an interactive Donut Chart in Power BI showing region-wise profit using the Superstore Dataset. We'll also add a drillthrough feature that lets us click on a region like 'West' and explore its detailed data on a separate page."

🟢 2. Load the Dataset
Import the Sample Superstore dataset into Power BI.

Ensure the data includes fields like Region, Profit, State, Category, etc.

🟢 3. Create Donut Chart
In the main report page:

Insert a Donut Chart

Drag Region into the Legend field.

Drag Profit into the Values field.

Add Data Labels and format the chart with your desired colors and styles.

Rename the chart title to "Region-wise Profit".

🟢 4. Create a Drillthrough Page
Add a New Page and rename it to Drillthrough - Region Details.

Drag the Region field into the Drillthrough Filters pane (right side).

On this page, insert visuals like:

Bar Chart or Table showing State vs Profit

Optional: Add visuals like Category vs Profit to explore further insights.

🟢 5. Link the Donut Chart with Drillthrough
Go back to the main Donut Chart.

Right-click on a region (e.g., West) and choose Drillthrough → Drillthrough - Region Details.

You’ll be navigated to the second page, now filtered only for the West Region.

🟢 6. Test and Format
Test drillthrough for all regions (East, Central, South, West).

Format both pages with clear titles, background colors, and navigation buttons if needed.

🟢 7. Final Touches and Summary
Add a Back Button on the drillthrough page (Insert → Buttons → Back), which allows users to return to the main page.

Summarize the benefit: "Using Drillthrough makes your Power BI reports interactive and lets end-users explore data in detail based on their selection.