Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Tornado Chart zero values

Hi all,
I have used Tornado Chart 2.1.0 in my report. It works fine when we have non zero values in the chart. But when all the values are zero, instead of zero length bars the visual shows full length bars as shown below.

Does any one know how to fix this behaviour?

  • Anonymous , It may be because of all values in 0 , if there is some value other than 0, it might not.

     

    You can make 0 values as blank, that might work

3 Replies

  • Anonymous , It may be because of all values in 0 , if there is some value other than 0, it might not.

     

    You can make 0 values as blank, that might work

    • Dr123's avatar
      Dr123
      New Member

      This is not a solution but a workaround for a bug in the app. (I have this issue too).
      Microsoft should fix this bug in Tornado 2.1.0 as 0 is 0 and should never display as 100% of a column?

      I cannot set values to blank as the measure needs to return zero instead of blank in order to highlight combinations of attributes with no data...

  • Anonymous's avatar
    Anonymous
    Not applicable

    Same issue here too, my workaround was to add in:

    IF(Result = 0, "0", Result) that fixed it