topic Re: A Glimpse into Michigan's Children in Poverty in Data Stories Gallery

A Glimpse into Michigan's Children in Poverty

deldersveld — Tue, 21 Feb 2017 03:43:39 GMT

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

Re: A Glimpse into Michigan's Children in Poverty

Anonymous — Fri, 10 Mar 2017 20:15:14 GMT

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.

Re: A Glimpse into Michigan's Children in Poverty

deldersveld — Fri, 10 Mar 2017 20:36:21 GMT

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

Re: A Glimpse into Michigan's Children in Poverty

Anonymous — Fri, 10 Mar 2017 22:58:46 GMT

Thank you!

Re: A Glimpse into Michigan's Children in Poverty

Anonymous — Wed, 15 Mar 2017 19:06:53 GMT

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

Re: A Glimpse into Michigan's Children in Poverty

deldersveld — Wed, 15 Mar 2017 20:12:46 GMT

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

Re: A Glimpse into Michigan's Children in Poverty

Anonymous — Thu, 16 Mar 2017 12:51:12 GMT

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