2.7 What is Include & Exclude in Power BI | Power BI Tutorials for Beginners | By Pavan Lalwani

#pavanlalwani #powerbi #dashboarddesign #dataanalytics

In this informative video, we will discuss the concept of include and exclude filters in Power BI Desktop. Understanding these filters is crucial for effective data analysis and visualization. We will create a simple stacked column chart to demonstrate their usage. By selecting specific subcategories, sales values, and regions, we can compare and analyze data easily. The include filter allows us to focus on selected values, displaying only those in the chart. Conversely, the exclude filter enables us to remove unwanted values from the visual representation. We will also explore how these filters can be applied and undone effortlessly. By the end of this video, you will have a clear understanding of how to use include and exclude filters in Power BI Desktop, empowering you to create impactful visualizations independently.
---------------------------------------------------------
💼 Invest in your future with our Power BI 2023 NEW Course at an incredible 50% discount:

📚 200+ MCQs to test your knowledge.
📝 20+ Assignments for hands-on practice.
🔍 11+ Case Studies for real-world insights.
💼 5+ Industry Projects to build your portfolio.
🎓 Course Completion Certificate for your resume.
💡 Tips & Tricks to boost your skills.
🔎 5+ Industry Datasets for practical learning.

Join thousands of professionals who have transformed their careers. Enroll now at 50% off!
You can also explore our Power BI DAX 2023 course and get a 360º understanding of DAX

Invest in yourself. Become a Power BI expert. The future is yours! 💼💪"

#datacleaning #businessintelligence #powerbi #powerbitraining #microsoftpowerbi
---------------------------------------------------------
Timestamps:
00:00:03 Understanding Include and Exclude 🤔
00:00:24 Focus Mode for Enhanced Viewing 🔎
00:00:54 Comparing Regions: West vs East 🌍
00:01:19 Filtering Subcategory and Region 📊
00:01:44 Undo or Remove Filters 🔄
00:02:13 Comparing Different Categories 📈
00:02:38 Using Exclude to Remove Values ❌
00:03:03 Visual Effects of Exclude ❌
00:03:31 Self-Filtering with Include and Exclude ✅

[PavanLalwani]

🚀 Calling all data enthusiasts! 💼🌟

👉 Discover the power of Power BI with our Specialization course at a jaw-dropping 50% off!


💥 Level up your analytical game and supercharge your career with the Power BI DAX course. 💯💼

[tr-GoodVibes]

Those who are struggling with the include and exclude options.
step1 : Press CTR+Select bars
step2 : Leave CTR button
Step3 : Now put cursor on selected bars and click right mouse button you will get options

Note : Don't do Step 3 while pressing CTR button

[sourishsood]

thank you pawan bhai for this power bi series. those who want to learn power bi from scratch this is the best video series on youtube. requesting you to please make tutroials on dax functions as soon as possible

[surabhijagadish]

Thanks you sir for helping me understand this filter.

[harshkoshta]

really amazing explanation love you sir

[EliseNshuti]

Instructor is good but I will make much more impact to post sample data to follow along. Thanks

[shaikasif]

00:14 Include and Exclude in Power BI
01:02 Understanding the concept of include and exclude in Power BI
01:18 Click on Subscribe for Updates
01:58 Subscribing to Quint and exploring the output
02:12 Include and Exclude in Power BI help in filtering data.
02:25 Understanding the concept of Include & Exclude in Power BI
03:08 Include and Exclude in Power BI
03:49 Include and Exclude in Power BI
Crafted by Merlin AI.

[shaiktasleemanasrin]

For those who are struggling with ctrl + click hold ctrl button and drag on the bars which you want to select

[bibekanandabhattacharjee]

I guess in most of the visualizations, the legend (field) is similar to a column used in 'group by' clause in a SQL (e.g.select ) statement.

[devinenipradeep]

How to send power bi reports qa and testing and please uplode more videos

[chinnavenkat]

Hi not able to get the include and exclude option

[Helloworld-uzmk]

Please someone help me. when i right click it doesnt show the any options like in video. It shows show as table, analyza, group, clear selections and summarize.

[tetzki]

CTRL + click doesn't work for me, instead it loads a spreadsheet or a data point as table.

[sudhavani]

Hai sir, can we able to save that include or exclude reports in that mode??, if yes means, how sir please repl me, thankyou in advance

[raghur]

Hi Pavan, I am using Mac and tried this option but when I right click on the bar this option is not showing up. Can you please explain what could be the reason?

[bhushankamble]

how can we decide that which value goes to axis column

[amitsondhiya]

Sorry sir this includes and exclude function is not available what I do . Their is any way

[monishajothi]

Hi, Almost 49 videos are hidden and not available... it would be great if we get that too...

[rohanrathod]

Does excel shortcuts work with power bi??

[Helloworld-uzmk]

Hello sir, it seems so many of them have had this issues in the past. can you please kindly reply???