Building the dashboard (Part 2)

Adding the switch button

Section two is a little more complicated.

We are going to use two visual (Shape Map and Table) and four images to switch between those visuals.

To add the images select, Insert -> Image

For now keep the switch on and off images apart and with the same size.

The Map visual

In the the US map we want to show the State color intensity proportional to the population of the census year.

Select the Shape Map visualization

If this option is not available in your Visualization bar, update Power BI desktop to the most current version or look for Shape Map in the preview features option.

For the Location drag and drop the state_name column from the States table.

For the Color Saturation select the total_population measure

Finally, rename the selected visualization columns state_name-> State, total_population-> Population.

The Table visual

It is important to keep the Map visual and the Table visual apart, in the same way we did with the images.

The table needs to show State Name and selected year Population, percent compare to the total US population, population change from the previous census and the change percentage.

We add the table visual and the necessary columns and measures.

To format the table select the Alternating rows Style

Change the conditional formatting for Population, Population Change and Change % using the color_pop_change calculated measure (you will need to do this change one column at the time)

final result

The switch button functionality.

To be able to change between map and table using the switch on and off button we are going to create two Bookmarks. Each bookmark will show and hide visuals depending in your selection.

This approach is handy to save dashboard "real state" to later add the Top 10 counties population chart.

First, in the View Menu select Bookmarks and Selection

Add a new Bookmark called ShowMap, hide the Table and corresponding switch button image

update the bookmark

Create another bookmark called ShowTable, and repeat the process hiding the Map and showing the table

Now we only need to assign the Action for the switch on-off images to the corresponding bookmarks

Overlap the Map-Table visuals and the switch on-off images, for the final result.

Comments

Building the dashboard (Part 1)

To show how to create the dashboard I divided the canvas in 3 sections I going to dedicate one post for every section, and the another 2 posts for the tooltip and drill through Adding Census Year slicer First we are going to add the census year filter. This filter will affect all visual in our dashboard. Select the slicer visual and the census_year field from the US Population ACS5 table Before diving into specifics formats, disable/enable the following formatting options to match the bellow image. Now in the selection control section change to Single select Change the Text size, Alignment, and Color for Items, Title and Border sections The final result Adding the Cards Select the Card visual and drag and drop total_population measure into the Fields box Rename the Fields from total_population → Total Population The formatting options are: In the Data label section, change...

Building the dashboard (part 3)

Adding the top 10 counties chart We are going to add to the Census Dashboard a bar chart to show the top 10 most populated counties, also if you select States in the Map/Table, the chart need to update properly, for example if you select California and Texas in the Map, the chart needs to show the top 10 counties combining only those two States. First we add a clustered bar chart, using County name and total_population for the Axis and Values respectively. then modify the County Filter to only include the top 10 counties by total population Now we need to change how the Map/Table interaction filters the bar chart data. Select the Map, and then Format/Edit Interaction in the ribbon. Change the bar chart interaction type from Highlight to Filter Now switch to the Table visual and repeat the process Select the bar chart change the Title Text to the calculated measure chart_header. select the measure The next post will be dedicated to adding the Drill...

Modifying the model

Adding new measures. This is a simple dashboard, just one filter (census survey year) and few calculated measures. The measures are: Total Population Previous Year Population Change Percent Population Change Percent of US Population also, there are two calculated measures to format and add additional information to the dashboard. Value color (Green if current year population is greater than previous year population otherwise Red) Most populated counties chart header (to show selected states) To add a new measure, right-click on the US Population ACS5 table and select New Measure the add the formula for total_population and select the thousands separator format Repeat this process to add prev_census_tot_pop = VAR PreviousCensusYear = MAX ( 'US Population ACS5'[census_year] ) - 1 RETURN CALCULATE ( ...

SQLBIDA

Search This Blog