Forum Discussion
TeresaV
5 years agoFrequent Visitor
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?
| Japan | 1 |
| Portugal | 2 |
| France | Data N/A |
| England | 5 |
| Italy | 6 |
| Spain | 412 |
| Russia | 10 |
| Germany | 1 |
| USA | Data N/A |
| Canada | Data 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
Community Support
Hi TeresaV ,
Could you pls share your pbix file?Remember to remove confidential data.
Best Regards
Lucien