Tornado chart population age pyramid with filters

[Rafa52]

Hi everyone,

I'm trying to build a report to show an age-gender-pyramid for diferent countries. I would like to show the population distribution for a single country and also be able to see other countries' results with a filter (one at the time). Right now the only thing I can do is create the tornado chart for one country but I can't add a filter that allows me to show the results for other countries.

As a reference I include a diagram of the visualization I want to create. 

Desired tornado chart filtered by country

Any help would be appreciated

[Anonymous · Accepted solution]

File attached.

Best

D

[Rafa52]

Hi darlove,

The file you sent me helped me a lot to understand Power BI's logic. I was able to replicate the exmple but I had trouble doing the sort part. I tried a couple of things sorting the look up table but did not work. Also I noticed you used something similar to a measure to create the statistics table.

I share my example

https://drive.google.com/open?id=1FHEa0pbV9UkxgGVFDmvH7vJlLS18OqRQ

By the way thanks for the help

[Ashish_Mathur]

Hi,

That takes us to a sign-in page.  PLease also show the exact sort order that you are expecting to see in the graph.

[Rafa52]

Now it is open everyone with the link can check it out

thanks in advanced for any help

[Ashish_Mathur]

Hi,

See the screenshot.  Click on the 3 dots and select Sort adscending.  Then go to Sort By > Age.

[Rafa52]

It seems to me that you got it.

Let me carefully check the file to understand what you did, by the way I forgot to say that I'm kind of new in Power BI.

Thanks