Forum Discussion
Waterfall Chart not using dates
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
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
Ok David thank you, im use to VBA and Excel formulas, am very new to Power BI and DAX, amd M and R, so am itrying to get my head around it, thank you for explaining the problem, i will give it a go see if i can get it done :)