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
To all of you dedelman_clng Eric_Zhang Sean and Phil_Seamark thank you all for your help its finally how i want it to look, all except the total bar, but im not stressing over that for now, thanks again
It is great to hear you finally figured it out. If no further questions, you can accept the replies making sensing as solution to close this thread. For any new questions, you can raise another thread.:smileyhappy: