Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

shorted waterfall chart

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

 

 

Need Help
Tips and Tricks
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi Anonymous ,

     

    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!

     

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , Not sure I got it completely.

    But a measure like this can help

    calculate([measure],filter(table[measure]>=10000 || table[measure]<=-10000))
  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    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!