cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NourJ Regular Visitor
Regular Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Tornado chart

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)

Capture.PNG

 

 

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
SabineOussi Established Member
Established Member

Re: Tornado chart

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 Regular Visitor
Regular Visitor

Re: Tornado chart

@SabineOussiI will try it, thank you so much Smiley Happy

Highlighted
Community Support Team
Community Support Team

Re: Tornado chart

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)

Capture.PNG

 

 

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.
NourJ Regular Visitor
Regular Visitor

Re: Tornado chart

@v-frfei-msft thank you so much