cancel
Showing results for
Did you mean:
Regular Visitor

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.

Nour

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team

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)```

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Established Member

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.

Regular Visitor

@SabineOussiI will try it, thank you so much

Highlighted
Community Support Team

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)```

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regular Visitor