In this data play, we look at publicly available London population projection data (from data.london.gov.uk) and create a visual story. Learn all about,
Creating population pyramid charts
Using what-if parameters to select input values
Applying conditional formatting to highlight selected year(s) values.
We will be creating this:
Have a play…
Feel free to mash-up this data to create something on your own. Share it with others by posting the uploaded file link (either upload it to PowerBI.com or somewhere else) so we all can learn from each other.
Author: Chandoo
My name is Chandoo. I am going to make you awesome in Excel, VBA, Dashboards, Power BI & Power Pivot and answering your questions.
I live in Wellington, New Zealand. It is a beautiful, small city on the southern edge of the world. I run my own Excel Consulting & Training business from here.
I am married to my college sweet-heart, Jo. We have 2 kids – twins. They are 10 years old now. They are busy creating new worlds with lego bricks or playing or learning. We (Jo &I) are busy with cooking, eating, walking, talking and reading.
View all posts by Chandoo
One thought on “Data Play – London Population in Future”
Your usage of Year Type as the source of conditional formatting is very clever.
Your usage of Year Type as the source of conditional formatting is very clever.