Forum Discussion
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...
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)
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.
SabineOussiI will try it, thank you so much :)
