SQLBIDA

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...

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 ...