Forum Discussion
add a calculated column to the Date Table
Hi, I need to add a calculated column to my date table to show 1 if the date = 2020.01.01 and if the date is = todate.The purpose is i need to show in my water fall chart x axis like this, so...
Anonymous
I do not think make 1st jan and today = 1 is necessary.
Please see this doc to learn how to use Waterfall chart in power bi. To get the visuals link the image you need to put the date in the Category(x-axis) and sales in the Values(Y-axis), and add the breakdown column. You can also find a lot videos on YouTube if you search Power bi waterfall.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.