shorted waterfall chart

[fanisgeorg]

Hello all

Apologies if this is a repost, keep receiving an error message when I try to post my message.

I am looking to create a visual, preferably a waterfall, where I only want to see categories that are either higher than 10K or lower than -10K. All other categories should be aggregated to a new category called lets say OTHER.

I believe this is only possible to happen with DAX. Or is they any shorting option in the waterfall chart or something from the market place that allows such separation.

Thanks

Fanis

[v-kelly-msft · Accepted solution]

Hi @fanisgeorg ,

Create a calculated column as below：

Column = IF('Table'[Value]>1000||'Table'[Value]<-1000,'Table'[Column2],"other")

Then put the column and value in a waterfall chart, and you will see:

For the related .pbix file,pls click here.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[fanisgeorg]

Thanks @v-kelly-msft and @amitchandak 

I got it

Tnx

F

[amitchandak]

@fanisgeorg , Not sure I got it completely.

But a measure like this can help

calculate([measure],filter(table[measure]>=10000 || table[measure]<=-10000))