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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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