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 ...
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!

     

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!

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks v-kelly-msft and amitchandak 

 

I got it

 

Tnx

F