Include and Exclude in Power BI Reports

Include and Exclude in the Microsoft Power BI graph chart

We have a bar chart that shows the sales data year wise as shown below:

In this chart we only want to compare two years, for that we use INCLUDE or EXCLUDE functionality by pressing the ctrl key on the keyboard, We select the 2012 and 2013 years. Right-click on the chart which shows both the include and exclude options.

Select Include option will keep only the 2012 and 2013 year bar graphs as shown below. In the Filters tab, we see one include filter is added. So we can filter or compare bar charts by using the include and exclude features in Power BI.

Remove this include, Go to the Filter tab and click on x.

Similar way, we can exclude the bar chart by selecting with the Control key and bar chart.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.