Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, I am trying to create a waterfall chart in PowerBI that looks something like this:
However, I do not know how to assign specific categories within my dataset to act as "totals" or subtotals".
I would appreciate someones advice on how to set-up my dataset and visual in Excel and powerBI, respectivelly.
Thank you very much in advance,
Kind regards.
Hello, I'm having the same problem. Did you find a solution? On Power BI, I only see Decrease, Increase and Total by default. There is no setting a category as a subtotal like in Excel. A nondynamic alternative workaround I used is to use Textbox with "Subtotal" label on the category bar to label the bar as a subcategory. Another alternative is to include Subtotal as part of the x-axis label category.
I also saw another post to import a custom waterfall visual from marketplace but I prefer to use Power BI visual on our desktop due to data privacy requirements. I've submitted an idea for subtotal waterfall, please vote!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.