Ex11# Utilize the Focus Mode of a Chart in Power BI
PreviousEx10# Implement Clustering in Power BINextEx12#Create a Combination Chart in Power BI: Bar Chart with Line
Last updated
Last updated
While looking at a visualization dashboard, you might want to look at more details of the report. This is where the focus mode in Power BI is useful. This guide will demonstrate how to utilize the focus mode of a chart in Power BI Desktop.
In this guide, you will work with a fictitious data set of bank loan disbursal across years. The data contains 3,000 observations and 17 variables. You can download the dataset. The major variables are described below:
Date: Loan disbursal date.
Loan_disbursed: Loan amount (in US dollars) disbursed by the bank.
Gender: Whether the applicant is female (F) or male (M).
Start by loading the data.
Once you open your Power BI Desktop, the following output is displayed.
Click on Get data option and select Excel from the options.
Browse to the location of the file and select it. The name of the file is BIdata.xlsx, and the sheet you will load is BIData sheet. The preview of the data is shown, and once you are satisfied that you are loading the right file, click Load.
You have loaded the file, and you can save the dashboard. It is named PowerBI Visualization. The Fields pane contains the variables of the data.
To begin, click on the Clustered column chart option located in the Visualizations pane. This creates a chart box in the canvas. Nothing is displayed because haven't yet added the required visualization arguments.
You can resize the chart on the canvas. The next step is to fill the visualization arguments under the Fields option as shown below. Drag the variable Date into the Axis field, and Loan_disbursed in the Values field.
The output above shows the Loan_disbursed by Year chart. You are now ready to explore the focus mode.
The focus mode is a little icon at the bottom of the chart as shown below.
Click on the focus mode option as shown above, and what it does is that the visual takes over the entire space in the report canvas, as shown below.
You also get access to a few other options with the three dots … symbols as shown below.
Click on the Show as a table option shown in the chart above, and it results in a table view along with the visual.
The layout can be changed with the Switch to vertical layout option.
Selecting the option above will align the table vertically alongside the visual.
You can also export data with the option available.
The other advantage of focus mode is that you can add variables into the chart. Drag the Gender variable into the Legend option as shown below.
The output above shows that the variable Gender is added to both the column chart as well as the table.
Focus mode is an important feature in Power BI as it enables deeper exploratory analysis of the visual. This helps in understanding underlying patterns that would have been difficult to identify otherwise. This is a great feature to use for treating outliers, exploratory data analysis, and to enrich your visual charts.
