Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
shihanhh
Frequent Visitor

Horizontal Tornado Chart

Is there an option to rotate Tornado chart or a horizontal chart similer to tornado chart ?

2 ACCEPTED SOLUTIONS
Uzi2019
Super User
Super User

Hi @shihanhh 
Sadly, There is no way you can rotate the tornado char. 
and I have search on App source I could not find the horizontal version of tornado chart. Not even in paid version.


If my post helps give kudos and accept it as a soultion!
Thanks

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

View solution in original post

Hi @shihanhh 
There is no such type of graph available on Power BI.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

6 REPLIES 6
Uzi2019
Super User
Super User

Hi @shihanhh 
Sadly, There is no way you can rotate the tornado char. 
and I have search on App source I could not find the horizontal version of tornado chart. Not even in paid version.


If my post helps give kudos and accept it as a soultion!
Thanks

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
Ritaf1983
Super User
Super User

Hi @shihanhh 

Please show the desired result

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Somthing similar to this. 

 

shihanhh_0-1697576068947.png

I have create this by joining two clustered column charts, one inverted.

Hi @shihanhh 
Technically you can achieve it by multiplying values that you want to be under 0 with -1
and hiding "-" of the y-axis with a white shape.
I recorded a short video of creating, you can download it from the link:

Link to mp4 

This is the result:

Ritaf1983_0-1697601067989.png

 

From the aspect of effective data visualization, these graphs are just unreadable.

Highly recommend reading my blog post about the why and alternatives :

https://community.fabric.microsoft.com/t5/Community-Blog/Why-Tornado-is-a-disaster-even-as-a-graph/b...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

I appreciate the work you've put in, but this isn't what I'm looking for. It doesn't display both the positive and negative aspects for each month or QTY as Tornado does. What I'm after is the enrollment and withdrawal data for each QTY or month over the past four years. I managed to achieve this for one year using Tornado, but I also want to present it horizontally. Therefore, I merged the column chart as sent ealier. That does the work but the lines are not alined when I change it to months. (Some lines are thiker that negative lines)

Hi @shihanhh 
There is no such type of graph available on Power BI.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors