Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
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?
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!
thanks. is the pbx still available?
Hi Kelly, I got an email from you asking if the waterfall question had been answered. I appreciate your reviewing what I had done, but... Not quite yet. In a followup, I responded with an example showing a begin value.
I have been doing additional reading - and I think this is a limitation of PBI. I found a reference, asking to vote on it - and as I dug, there were multiple like kind requests. So, unless something new has recently transpired - I'm not hopeful. But - maybe you have some magic 🙂
thank you@
Thanks, but not quite... I found an WF image with the concept I want to shoot for. In my example, the first bar would be the 2018 value of 13.33 and the red/green bars represents the 2019 changes in Labor, Supplies, and fuel. The ending bar would add up to $17.
Thank you again!