In Power BI, the concepts of "Include" and "Exclude" are used to refine and manipulate data visualizations. Here's a brief overview of how you can use these features:

Include

The "Include" feature allows you to focus on specific data points within a visualization. When you include data points, Power BI filters the visualization to show only the selected data.

Steps to Include Data Points:

Select Data Points: Click on the data points you want to include in your visualization.

Right-Click: Right-click on the selected data points.

Choose Include: From the context menu, select "Include."

This action will filter the visualization to display only the selected data points, helping you to analyze specific segments of your data.

Exclude

The "Exclude" feature allows you to remove specific data points from a visualization. When you exclude data points, Power BI filters the visualization to hide the selected data.

Steps to Exclude Data Points:

Select Data Points: Click on the data points you want to exclude from your visualization.

Right-Click: Right-click on the selected data points.

Choose Exclude: From the context menu, select "Exclude."

This action will filter the visualization to hide the selected data points, allowing you to focus on the remaining data.

Practical Example

Imagine you have a sales report visualization showing sales by region. If you want to focus only on the sales data for the "West" and "South" regions, you can use the "Include" feature to filter out other regions. Conversely, if you want to exclude the "North" region from your analysis, you can use the "Exclude" feature to remove it from the visualization.

Tips

Multiple Selections: You can select multiple data points by holding down the Ctrl key while clicking.

Clear Filters: To clear the filters applied by Include or Exclude, you can use the "Clear Selections" option in the context menu or the filter pane.

These features are powerful tools in Power BI that help you tailor your visualizations to better meet your analytical needs. If you have any specific scenarios or further questions, feel free to ask!