cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yoshihirok
Post Prodigy
Post Prodigy

How can I use the TornadoChart for population per gender and age ?

How can I use the TornadoChart for population per gender and age ?

I want to create the report of population chart per gender and age by TornadoChart.

 

I cannot make gender left and right chart.

I want to Y asix is age group and, X axis populations, and left/right to gender.

 

Regards,

Yoshihiro Kawabata

1 ACCEPTED SOLUTION
PowerDAX
Resolver III
Resolver III

The intent of the Tornado Chart looks to be to compare two measures against the same dimension.  Add one dimension in the group field and two measures in the values field.

 

You can take a look at my writeup covering the new custom visuals and download an example pbix file here: http://bit.ly/1k1uDDo

powerdax.com

View solution in original post

4 REPLIES 4
PowerDAX
Resolver III
Resolver III

The intent of the Tornado Chart looks to be to compare two measures against the same dimension.  Add one dimension in the group field and two measures in the values field.

 

You can take a look at my writeup covering the new custom visuals and download an example pbix file here: http://bit.ly/1k1uDDo

powerdax.com

View solution in original post

Excellent Thank you PowerDAX.

 

I will start reading your article "AdventureWorks Power BI Visualization Samples".

 

Best Regards,

Yoshihiro Kawabata

itchyeyeballs
Impactful Individual
Impactful Individual

Thank you PowerDax,

 

Your write up and the example pbix file is really usefull. 

 

I just hope MS find a way to make writing and managing measures more user friendly as given you have to write multiple seperate measures i.e total1, total2 i find it becomes unweildy to keep track of them all, some way of grouping measures and adding comments would be a start.

 

Would love to see an extra group by option against some of these visualisations where users just drag the relevant group field, would cut down on number of measures in some circumstances and also help to design furture proof analysis where you don't have to change the measure(s) if the data changes slightly.

 

 

itchyeyeballs
Impactful Individual
Impactful Individual

Are you using the Tornado chart from the new visuals gallery? If so I'm having the same problem, there doesn’t seem to be a way to select the "left/right" groups (although I'm probably missing something)

I have a similar issue with the radar plot where the visual seems to imply you can overlay two groups in the same chart and the bullet chart which seems to imply you can have one chart for each group, I can’t figure out how to do this though.

It would be good if there was user documentation available via the visuals gallery to explain how the charts work.

Edit - I figured out the radar plot, I need two separate measures rather than being able to pick a column to group by.

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors