Forum Discussion
Waterfall chart start valu
Hello
I am attempting to use PBI waterfall chart to show begin values, changes = that add up to the end value. My base measure is Cost$/unit, which is an annual value. For example, 2018 $/unit = $400, and ending value 2019 is $525/unit, I do have a measure reflecting the YOY change by ledger - but would now like to transition to a waterfall chart, with the inital bar = $400, and then with all the +/- end up at $525. I have a year slicer, so the starting point would be selected value - 1.
There are multiple similar questions already posted - with one solution being a measure. The other responses are purchasing a commercial visual (probably not likely). The solution with a measure assumes the initial value is in the dataset - I was unable to make work, as the beginning value was included on allowed dates within the slicer. My initial value is prior years calculated $/unit.
Appreciate your reponses!
6 Replies
- v-kelly-msftCommunity Support
Hi Dellis81 ,
I cant simply create a sample data based on your description,so would you pls upload your .pbix file to onedrive business and share the link with us?
Best Regards,
KellyDid I answer your question? Mark my post as a solution!- Dellis81Post Prodigy
Thank you for taking time to help. Here is a link to OneDrive with a simple example.
I would like the initial bar, representing 2019 for value of $13.30, and then for each category (Labor, Fuel, Supplies) show the YOY change, with the ending bar totaling $16.96.
I sure hope this can be done! Thank you!
- v-kelly-msftCommunity Support