Data Filtering Through Slicer ka matlab hai Excel mein Slicer ke buttons ka use karke Pivot Table ya Pivot Chart ke data ko quickly filter karna. Slicer ek visual filter ki tarah kaam karta hai, jisme categories buttons ke form mein दिखाई देती हैं.

🔹 1. Data Filtering Through Slicer kya hai?

Normally Pivot Table mein filtering ke liye dropdown arrow ka use kiya jata hai. Lekin Slicer mein filter options directly buttons ke form mein दिखाई देते हैं.

Example:

CITY

[Delhi] [Rohini] [Nangloi] [Pitampura]

Agar hum Delhi par click karte hain, to Pivot Table mein sirf Delhi ka relevant data show hoga.

📊 2. Example – Sales Data

Maan lijiye hamare paas sales data hai:

Pivot Table:

Rows → City
Values → Sales

Ab City ka Slicer add karte hain.

Slicer:

CITY

[Delhi]
[Rohini]
[Nangloi]

Agar Rohini select karenge, Pivot Table sirf Rohini ki sales information show karegi.

🛠️ 3. Slicer ke Through Data Filter Karne ke Steps

Step 1 – Pivot Table Select Karein

Pivot Table ke kisi bhi cell par click karein.

Step 2 – Slicer Insert Karein

Go to:

PivotTable Analyze → Insert Slicer

Step 3 – Field Select Karein

Example:

☑ City
☐ Product
☐ Month

City select karein.

Step 4 – OK

Ab City Slicer worksheet par दिखाई देगा.

Step 5 – Filter Apply Karein

Slicer mein required category par click karein.

Example:

Delhi

👉 Pivot Table automatically Delhi ka data show karegi.

🎯 4. Single Data Filter

Agar sirf ek category select karni ho, to simply us button par click karein.

Example:

[Delhi] ✓
[Rohini]
[Nangloi]

Result:

Only Delhi data

🔢 5. Multiple Data Filtering

Slicer se ek se zyada categories bhi select ki ja sakti hain.

Example:

[Delhi] ✓
[Rohini] ✓
[Nangloi]
[Pitampura]

Ab Pivot Table:

Delhi + Rohini ka data show karegi.

Multiple selection ke liye Slicer mein Multi-Select option ya Ctrl key ka use kiya ja sakta hai.

❌ 6. Filter Remove Karna

Agar filter हटाना हो, to Slicer ke top-right mein Clear Filter icon par click karein.

Isse Pivot Table mein complete data dobara दिखाई देगा.

📋 7. Multiple Slicers se Filtering

Ek report mein multiple Slicers use kiye ja sakte hain.

Example:

CITY
[Delhi] [Rohini] [Nangloi]

PRODUCT
[Laptop] [Mobile] [Tablet]

MONTH
[Jan] [Feb] [Mar]

Ab hum combination filter laga sakte hain:

City = Delhi
Product = Laptop
Month = January

👉 Pivot Table selected conditions ke according data show karegi.

💼 8. Practical Business Example

Ek company ke paas sales data hai:

Pivot Table mein:

Rows → Salesperson
Values → Sales

Slicers:

• City
• Product
• Month

Manager easily check kar sakta hai:

Delhi mein Laptop ki sales kitni hai?

Bas City = Delhi aur Product = Laptop select karna hai.

🎓 9. Student Report Example

Student data ko Pivot Table mein summarize kiya gaya hai.

Rows → Course
Values → Average Marks

Slicers:

• Course
• Batch
• Gender

Agar Course = Digital Marketing select kiya jaye, to report mein sirf Digital Marketing students ka relevant analysis दिखाई देगा.

📈 10. Slicer + Pivot Chart

Slicer ko Pivot Chart ke saath bhi use kiya ja sakta hai.

Raw Data
   ↓
Pivot Table
   ↓
Pivot Chart
   ↓
Slicer
   ↓
Filter
   ↓
Chart Automatically Updates

Example:

City Slicer → Delhi

Select karte hi Pivot Chart bhi Delhi ke data ke according update ho sakta hai.

🌟 Slicer Filtering ke Advantages