Skip to content Skip to sidebar Skip to footer

Power Bi Bar Chart Show Only Selected Data

Power BI is a powerful tool used for data visualization and business intelligence. With Power BI, you can create customized charts and graphs to represent your data in a way that is easy to understand. One of the most commonly used charts in Power BI is the bar chart, which is used to compare different categories of data. In this article, we will discuss how to show only selected data in a Power BI bar chart.

What is a Bar Chart?

A bar chart is a chart that represents data using rectangular bars. The length of each bar is proportional to the value of the data it represents. Bar charts are used to compare different categories of data and are especially useful when dealing with large amounts of data.

Bar Chart Power Bi

Filtering Data in a Bar Chart

Power BI allows you to filter data in a bar chart by selecting specific categories or values. To do this, you need to add a filter to your chart. You can add a filter to your chart by clicking on the "Visualizations" button in the right-hand pane and selecting "Filters" from the dropdown menu.

Power Bi Filters

Once you have added a filter to your chart, you can select the categories or values that you want to show in your chart. To do this, simply click on the drop-down menu and select the categories or values that you want to include.

Power Bi Filter Data

Showing Only Selected Data in a Bar Chart

If you want to show only the selected data in your bar chart, you need to use the "Drill Through" feature in Power BI. The Drill Through feature allows you to create a new page in your report that shows only the data that you have selected in your bar chart.

To use the Drill Through feature, you need to create a new page in your report and add a table or matrix visual to the page. Then, you need to add the fields that you want to show in your table or matrix visual.

Power Bi Drill Through

Once you have created your new page and added your table or matrix visual, you need to add a Drill Through filter to your visual. To do this, click on the "Visualizations" button in the right-hand pane and select "Filters" from the dropdown menu. Then, click on the "Drill Through" button and select the fields that you want to include in your Drill Through filter.

Power Bi Drill Through Filter

Once you have added your Drill Through filter, you can select the data that you want to show in your table or matrix visual by clicking on the bars in your bar chart. This will take you to the new page that you have created and show only the data that you have selected.

Conclusion

Power BI is a powerful tool for data visualization and business intelligence. With the ability to create customized charts and graphs, you can represent your data in a way that is easy to understand. By using the Drill Through feature in Power BI, you can show only the selected data in your bar chart and create a more focused view of your data. With these tips, you can create powerful and insightful visualizations that will help you make better business decisions.

Related video of Power BI Bar Chart Show Only Selected Data