Forum Discussion

NourJ's avatar
NourJ
Icon for Helper III rankHelper 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   No...
  • 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)

     

     

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity 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)