Skip to main content

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 the Display units to None, the Text size to 27 pts




for Color select the function button next to the color dropdown list



select Format by option Field Value, and then Based on field use the color_pop_change measure (Formatting folder). This is a good option if you want to change the criteria for how to visualize the color with a more complex formula, for example you want to use color green if the population increase is only by certain percent.

The other sections




the final result


We can now select the Total Population visual and Copy and Paste four times, align and change the fields to

  • prev_census_tot_pop
  • change_pct
  • total_male
  • total_female
rename the fields to
  • Previous Year Population
  • Change %
  • Male Population
  • Female Population
now select the Cards (holding down Ctrl key) Previous Year Population, Male Population and Female Population and remove the Data label color formula by clicking the "eraser". This action will remove the color Green/Red for these cards




Finally select all Cards and right-click to open the context menu and create a Group. This will made easy to move and resize all Cards at the same time.





The final result



In the next post we will show how to add the Top 10 more populated counties to the dashboard.




Comments

Post a Comment

Popular posts from this blog

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...
Post a Comment
Read more

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  (  ...
Post a Comment
Read more