A Glimpse into Michigan's Children in Poverty 02-20-2017 19:43 PM

[deldersveld]

I created this report after seeing a list of local youth service organizations published by the Detroit Free Press. It features simple visualizations based on US Census data from 2015. One unique feature is a Shape Map county "highlight" effect achieved by layering maps. Also uses a custom Shape Map showing the concentration of poverty in Detroit and how it falls on the services of only one public school district to work with the majority of children who are under the poverty line.

Data: http://www.census.gov/did/www/saipe

eyJrIjoiZTdhN2RkZjYtZjBiOC00OGJjLWI4NWYtMWQyOTAzNjg3MWU5IiwidCI6IjRlZmE3NzhmLTVmNmMtNDAxZS04OGFmLWNmMTliZDA5ZDE0OCIsImMiOjN9

[Anonymous]

Looks great! What DAX did you use to determine if one or more than one county were selected?

[deldersveld]

IF(HASONEVALUE('Poverty Data 2015'[County]), ..., ...)

[Anonymous]

Thanks, @deldersveld! Any chance you might post the full syntax? I am trying to translate years of Excel dev into DAX and I am not clear on how to get the filter context and to pass in a text value. So this hits two needs. Much appreciated!

Scott

[Anonymous]

The report looks great.

How did you manage to get Counties? I was looking to create a report by county but was not able to do it.

[deldersveld]

Thanks! I have a collection of topojson files that includes counties for all US states. There is no county map currently available out of the box for the Shape Map, so you have to use a separate file. Here's a link to my blog post with more detail on what's available as well as the direct link to all of the topojson files:

https://dataveld.wordpress.com/2016/09/12/topojson-map-files-for-power-bi-shape-map/

https://github.com/deldersveld/topojson

[Anonymous]

Thank you!