Re: A Glimpse into Michigan's Children in Poverty

1847 Views
Advisor
Posts: 363
Registered: ‎06-26-2015

A Glimpse into Michigan's Children in Poverty

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

Member
Posts: 93
Registered: ‎12-14-2016

Re: A Glimpse into Michigan's Children in Poverty

[ Edited ]

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.

Highlighted
Advisor
Posts: 363
Registered: ‎06-26-2015

Re: A Glimpse into Michigan's Children in Poverty

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

Member
Posts: 93
Registered: ‎12-14-2016

Re: A Glimpse into Michigan's Children in Poverty

Thank you! 

Member
Posts: 78
Registered: ‎12-09-2015

Re: A Glimpse into Michigan's Children in Poverty

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

Advisor
Posts: 363
Registered: ‎06-26-2015

Re: A Glimpse into Michigan's Children in Poverty

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

Member
Posts: 78
Registered: ‎12-09-2015

Re: A Glimpse into Michigan's Children in Poverty

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