Tornado chart

[NourJ]

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 · Accepted solution]

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)

[NourJ]

@v-frfei-msft thank you so much

[SabineOussi]

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.

[NourJ]

@SabineOussiI will try it, thank you so much 🙂