Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
87 | |
67 | |
49 |
User | Count |
---|---|
135 | |
112 | |
100 | |
68 | |
67 |