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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.