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
EDIT: The one thing about this Chart in PBI if I recall there's no option to turn off the Total...
Hi Sean
Thats how i want it to look, obviously the total is a nuisance, was this done by creating a data table in the desktop? i can give that a go see if i can connect it it my main data set im using
Hi Phil
How do i upload a data file? i can see how to upload photo/video
Almost too easy :smileylol: i thought there may be a attachent option like on excel forum, I have now uploaded an example data set into onedrive, im going to carry on trying in the desktop to see if i can build a data table to replicate Seans example, however im trying to run the chart straight from the data set as there is a lot of charts and tables that will be generated by this and linked to slicers, and dropdowns
https://1drv.ms/u/s!AhMWRjYUcisAhAV7Nl_vgRU_q4yK
Thanks
