Forum Discussion
Solved
Waterfall Chart not using dates
Hi Im very new to Power BI, literally only started playing with it yesterday, and there is a chart i use to do in excel, that i would like to replicate in Power BI, but, im finding this difficult...
I see in your dataset, the first step should be doing a unpivot.
Then replace the currency symbol with blank and convert that column to whole number.
In the waterfall chart, use the attribute and value column.
As to the axis order in the waterfall chart, check this thread Sorting Data Manually.
Check more details in the attached pbix file.
Add columns through the query editor uses M language not DAX (click "Advanced Editor" in the query pane to see the M code)
If you instead create a calculated column on the report layout page, your code is accurate.
Hope this helps
David
