Horizontal Tornado Chart

[shihanhh]

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

[Uzi2019 · Accepted solution]

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

[Ritaf1983 · Accepted solution]

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:

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

[Uzi2019 · Accepted solution]

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

[Ritaf1983]

Hi @shihanhh 

Please show the desired result

[shihanhh]

Somthing similar to this. 

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

[Ritaf1983 · Accepted solution]

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:

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

[shihanhh]

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)

[Ritaf1983 · Accepted solution]

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