Workout Wednesday: How Will the UK population Change By 2039?

Another fun Workout Wednesday challenge from Emma this week. She asked us to build a butterfly chart, something I'd never done before.

Conceptually, I knew exactly what I needed to do:

1. Create separate measures for males and females
2. Create additional measures to make them percentages by dividing by the population estimate
3. Create an LOD for the national average for males and females
4. Create additional measure to make them percentages
5. Make the male axis reversed
6. Set all of the axes scales to be equivalent (Emma didn't do this, but I think the axes should be the same on each side of the center)
7. Create the calcs for the rows and columns of the trellis
8. Add a filter for local authority and add that to the title
9. Throw is all together in a dashboard size 1000x800