Using Price + Volume + Mix Measures to create Sales Waterfall Chart in Power BI Tutorial

[@chrisdang7378]

Thanks for introducing the simple waterfall, which is exactly what I need. Excellent video.

[@LighthouseAnalytix]

My pleasure!

[@doumbesamuel6926]

Thank you, Thank you and Thank you again, this is exactly what i have been looking for for months. Excellent video.

[@LighthouseAnalytix]

You're very welcome!

[@vitazamb3375]

Thank you ! You solved my problem in minutes after I spend 4h watching youtube videos, trying PBI by myself and ChatGPTing.

[@LighthouseAnalytix]

You're welcome! Glad that the video is helpful😊

[@rossanderson5218]

Thankyou Thankyou Thankyou, This is exactly what i needed, I've been banging my head on trying to create a waterfall chart for so long now, where default waterfall charts and other visual weren't giving me my desired output mainly due to my employers nuance with there products and MRR data but also some limitations within the standard waterfall chart. this is perfect, 90% of the time keeping it simple is the best answer, thankyou.

[@LighthouseAnalytix]

You are most welcome :)... Glad to hear you finally found what you were looking for !!

[@erikbrown8886]

I wish microsoft would include the "Simple Waterfall" visualization as an option in their standard waterfall visualization... but this was EXACTLY what I needed. THANK YOU!!!

[@LighthouseAnalytix]

Good point!

[@DavidKalilBraga]

Thank you so much! Your explanations were totally clear, you showed not only how to create the graphic but the step by step guide and organization that will allow us to reply under our needs! You rock!

[@LighthouseAnalytix]

Glad it helped! :)

[@marshallstringfield9340]

Thank you so much. This was almost what I was looking for. However, one big problem: I implemented it into my data, but I didn't realize until the end that this visual doesn't allow you to click of the columns to use as a filter for the rest of the page like the default waterfall. This is a huge missing feature and what makes PowerBi so powerful. Unfortunately, back to the drawing board...

[@alejandroparodiherz]

Thanks for the simple and clear explanation. I will try !

[@LighthouseAnalytix]

You are welcome 😊

[@gennarocimmino]

Congratulations! Very interesting tutorial. Very well explained. Thank you for sharing it.

[@LighthouseAnalytix]

Thanks for your kind words... Glad you enjoy it...

[@Belinda-hu8bm]

Very useful tutorial, thank you. Is there a way to sort the measures appearing in the chart e.g. after the Start column, then Volume then Price and then Mix?

[@diogoazevedo8029]

Hi Isabella! Very nice tutorial thanks for sharing it! But theres is one thing that I still cant comprehend. If you select Product C and do the PVM Analysis between the years 2021-2023 the volume effect is 1.1K but the quantity its the same for each year. Shouldnt the volume effect be zero in this case?

[@petercompton538]

Amazing - very useful indeed

[@LighthouseAnalytix]

Glad you think so!

[@olcan]

Hello, great video. One question, i have products that have solde in the past, but not in the current year, and vice-versa. When I calculate the P1mix, price and revenue, and the P2mix, price and revenue, those products that appear on one year show the wrong data. Those are showing the same data for the year with zero sales, as the year with sales. It should show blank values in the Period drivers chart for years without sales. Do you know how to fix that? thanks

[@fpappalettera]

same issue is there any solution in the formula related to P1mix, p1price, p1total unit that solve the issue? @olcan did you find any alternative?

[@I-HsuanThompson]

Does anyone know how or if you can build this in Sigma computing (another BI software)? It's exactly what I need but having trouble to build in another platform(Sigma).

Thnanks very much!

[@LighthouseAnalytix]

you are very welcome.

[@vuongtuan89]

Thank you very much. Can you share working files into your comment, please.❤

[@aravindnayak1366]

Excellent and very innovative. Thank you very much for the video. Waiting for more videos! Just one doubt, I do not see the "Define Pillar" option in my power BI. How do I get it?

[@LighthouseAnalytix]

Thank you !! Are you using custom visual - 'simple waterfall' ?

[@karikoga320]

Great, can please do another one which includes new and discontinued products

[@LighthouseAnalytix]

Great idea!