Forum Discussion

NourJ's avatar
NourJ
Helper III
7 years ago
Solved

Tornado chart

Dear Community,

 

i am using the tornado chart to show the comparesion between two columns,

is there a way ( filter or measure maybe )to remove the equal values.

 

 

thank you in advance

 

Nour

  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi NourJ ,

     

    To create two meaures as below.

     

    V1 = var sum1 =SUM(Table1[value1])
var sum2 = SUM(Table1[value2])
return
IF(sum1=sum2,BLANK(),sum1)
    V2 = var sum1 =SUM(Table1[value1])
var sum2 = SUM(Table1[value2])
return
IF(sum1=sum2,BLANK(),sum2)

     

     

4 Replies

  • SabineOussi's avatar
    SabineOussi
    Skilled Sharer
    7 years ago

    Hi NourJ 

    Suppose the values to compare are in Column1 and Column 2,
    Create a new column Column3 = IF(Table1[Column1]=Table1[Column2], 0, 1)
    This will return 0 if the values are equal, 1 otherwise.

     

    Use Column3 as a visual level filter for the tornado chart and filter it on value 1 only.

     

    Hope this help!

    Sabine O.

     

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi NourJ ,

     

    To create two meaures as below.

     

    V1 = var sum1 =SUM(Table1[value1])
var sum2 = SUM(Table1[value2])
return
IF(sum1=sum2,BLANK(),sum1)
    V2 = var sum1 =SUM(Table1[value1])
var sum2 = SUM(Table1[value2])
return
IF(sum1=sum2,BLANK(),sum2)