Forum Discussion

TeresaV's avatar
TeresaV
Frequent Visitor
5 years ago

Waterfall Chart measure with non numeric values

I want to create a Waterfall chart with a measure. 

 

My measure turns the 0 values in "Data N/A".  How can I filter those types of values in Waterfall chart? 

Japan1
Portugal2
FranceData N/A
England5
Italy6
Spain412
Russia10
Germany1
USAData N/A
CanadaData N/A

 

This is the table after applying this measure: 
Measure=
var a=CALCULATE('Table'[Value])
return
if( a=0, "Data N/A", calculate(sum('Table'[Value]))


Thanks!
Jihwan_Kim amitchandak Anonymous daxer-almighty 

1 Reply

  • v-luwang-msft's avatar
    v-luwang-msft
    Icon for Community Support rankCommunity Support

    Hi TeresaV ,

    Could you pls share your pbix file?Remember to remove confidential data.

     

    Best Regards

    Lucien