{"id":176521,"date":"2024-01-16T19:42:01","date_gmt":"2024-01-16T18:42:01","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=176521"},"modified":"2024-01-16T19:46:58","modified_gmt":"2024-01-16T18:46:58","slug":"power-bi-waterfall-chart-overview-and-use-cases","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/power-bi-waterfall-chart-overview-and-use-cases","title":{"rendered":"Power BI waterfall chart: Overview and use cases"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"176521\" class=\"elementor elementor-176521\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d84edcd e-flex e-con-boxed e-con\" data-id=\"d84edcd\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2001184 elementor-widget elementor-widget-text-editor\" data-id=\"2001184\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<h2>The Power BI waterfall chart is a type of DataViz that visualizes changes between an initial value and a final value. Find out all you need to know about this graph: presentation, benefits, tutorial, training&#8230;<\/h2>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-945f068 elementor-widget elementor-widget-text-editor\" data-id=\"945f068\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><a href=\"https:\/\/datascientest.com\/en\/altair-everything-you-need-to-know-about-this-statistical-visualization-library\">To visualize data<\/a>, bar and column charts are ideal for initial and final values. However, this type of diagram doesn&#8217;t allow you to detail all the factors that led to the final value.<\/p><p>Fortunately, <a href=\"https:\/\/datascientest.com\/en\/optimizing-financial-insights-with-microsoft-power-bi-finance\">Microsoft&#8217;s Power BI software<\/a> offers an ideal format for this <a href=\"https:\/\/datascientest.com\/en\/dataviz-definition-objectives-and-uses\">type of DataViz<\/a>: the waterfall chart.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-026b8d6 e-flex e-con-boxed e-con\" data-id=\"026b8d6\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-051e238 elementor-widget elementor-widget-heading\" data-id=\"051e238\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h3 class=\"elementor-heading-title elementor-size-default\">What is a Power BI waterfall chart?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5dfeb04 elementor-widget elementor-widget-text-editor\" data-id=\"5dfeb04\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>In nature, a waterfall very rarely flows in a perfectly steep, uniform manner. Before reaching the river, waterfalls pass through the hollows and reliefs of the eroded cliff.<\/p><p>The<strong> same applies to the data passing from an initial value to a final value.<\/strong> That&#8217;s why the <strong>Power BI waterfall chart<\/strong> has such a colourful name, as it shows each individual component contributing to the final value.<\/p><p>A start bar represents the initial value, and begins from a baseline of zero. Two bars then appear to float in space: these are the transient values representing positive and negative changes to this starting value.<\/p><p>These changes can be time-based or category-based. Finally, the end bar<strong> represents the final value, taking into account the effects of all the transient values displayed.<\/strong><\/p><p>The cascade chart is sometimes nicknamed the bridge chart, as it allows you to quickly spot value rises and falls thanks to the colors of the columns.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e9a1e76 elementor-widget elementor-widget-image\" data-id=\"e9a1e76\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/09\/graphique-cascade10.jpg\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-18f69ed elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"18f69ed\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Discover our Power BI training<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-134b0e0 e-flex e-con-boxed e-con\" data-id=\"134b0e0\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d301d67 elementor-widget elementor-widget-heading\" data-id=\"d301d67\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Power BI waterfall charts and bar charts: what's the difference?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a0a1f42 elementor-widget elementor-widget-text-editor\" data-id=\"a0a1f42\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The<strong> waterfall chart<\/strong> is generally used for very specific use cases. Only some users use this type of diagram on a regular basis.<\/p><p>At first glance, many people confuse the waterfall diagram with a bar or column diagram. But the difference is quite simple.<\/p><p>A bar or column chart visualizes the total value of a measurement in each category using bars. Each bar has a zero baseline.<\/p><p>A waterfall diagram, on the other hand, shows positive and negative changes in a value. It therefore comprises a start bar and an end bar, each with a zero baseline.<\/p><p>Each floating bar in the middle has the end of the previous bar as its baseline. This baseline can start at the top or bottom, depending on whether the bar represents a positive or negative change.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b324018 elementor-widget elementor-widget-image\" data-id=\"b324018\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/09\/cascade-vs-diagramme.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1a238dc elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"1a238dc\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Discover our Power BI training<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-d9e6a74 e-flex e-con-boxed e-con\" data-id=\"d9e6a74\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-96cc004 elementor-widget elementor-widget-heading\" data-id=\"96cc004\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">When to use a Power BI waterfall chart?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-eec7658 elementor-widget elementor-widget-text-editor\" data-id=\"eec7658\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The waterfall diagram is used for very specific use cases, notably in finance. When it comes to visualizing changes in value, there&#8217;s really no alternative to the <strong>Power BI waterfall chart.<\/strong><\/p><p>In particular, <a href=\"https:\/\/datascientest.com\/en\/ggplot-everything-you-need-to-know-about-the-r-data-visualization-library\">this type of DataViz<\/a> is used for financial analysis and profit and loss statements. Generally speaking, this diagram allows you to visualize any cumulative value and its changes.<\/p><p>It is used to visually represent how a starting value becomes a final value through a series of intermediate operations, expenses and the balance of a bank account, to illustrate a company&#8217;s headcount at the beginning and end of the year, or to show changes or variance in various categories.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-5958797 e-flex e-con-boxed e-con\" data-id=\"5958797\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8039676 elementor-widget elementor-widget-heading\" data-id=\"8039676\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">What are the components of a waterfall chart?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-904a6a3 elementor-widget elementor-widget-text-editor\" data-id=\"904a6a3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>To add data to a<strong> Power BI waterfall chart<\/strong>, you need to fill in various fields. The category is represented by the horizontal axis, and specifies the columns dividing the chart.<\/p><p>Breakdown is used to specify the columns dividing the detailed data. Finally, values are used to specify the measurement columns represented by the vertical axis.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-704f88c elementor-widget elementor-widget-image\" data-id=\"704f88c\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/09\/graphique-cascade.jpg\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dce1369 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"dce1369\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Discover our Power BI training<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-4de6fd3 e-flex e-con-boxed e-con\" data-id=\"4de6fd3\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-961377b elementor-widget elementor-widget-heading\" data-id=\"961377b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Advantages and disadvantages of the Power BI waterfall chart<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-40e40dc elementor-widget elementor-widget-text-editor\" data-id=\"40e40dc\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The <strong>Power BI waterfall<\/strong> chart offers several major advantages. It&#8217;s easy to create, requires no special data preparation, uses a clear structure and effectively displays progressive changes over time. This chart is ideal for tracking a company&#8217;s performance over time.<\/p><p>On the other hand, customization options for this chart are limited. <a href=\"https:\/\/datascientest.com\/en\/google-data-studio-introduction-to-googles-dataviz-tool\">Nor is this form of DataViz suitable<\/a> for detailed data analysis, since it is not possible to extend the data or make a selection.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f83d4d1 e-flex e-con-boxed e-con\" data-id=\"f83d4d1\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-fa48d5a elementor-widget elementor-widget-heading\" data-id=\"fa48d5a\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Power BI waterfall charts: tips and tricks<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1117d34 elementor-widget elementor-widget-text-editor\" data-id=\"1117d34\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>As with any t<strong>ype of DataViz<\/strong>, it&#8217;s important to use colors to tell a story through the waterfall diagram. In particular, you can use different colors for negative and positive values, and a third color for initial and final totals.<\/p><p>To improve readability, you can also add connecting lines between each value. This avoids confusion between start and end values if they are close together, guiding the user&#8217;s eyes.<\/p><p>You can also use<strong> Power BI&#8217;s formatting features,<\/strong> adding legends and labels. Filter and variance options are also invaluable.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-67142b1 elementor-widget elementor-widget-image\" data-id=\"67142b1\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/09\/graphique-cascade1.jpg\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1f9bb26 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"1f9bb26\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Discover our Power BI training<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-43796c4 e-flex e-con-boxed e-con\" data-id=\"43796c4\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-43b92d3 elementor-widget elementor-widget-heading\" data-id=\"43b92d3\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How to create a waterfall chart from Excel?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-207aca4 elementor-widget elementor-widget-text-editor\" data-id=\"207aca4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>As an example, here&#8217;s how to create a Power BI waterfall chart from Excel data. Start by downloading a sample of Excel data from the browser, or preparing it as required.<\/p><p>On <a href=\"https:\/\/datascientest.com\/en\/power-bi-desktop-download-and-installation-guide\">Power BI Deskstop,<\/a> go to &#8220;Get Data&#8221; and then Excel to select your data. Then click on &#8220;Open&#8221;, and select the data on the browser page that appears.<\/p><p>To transfer the data from the <a href=\"https:\/\/datascientest.com\/en\/power-bi-direct-query-vs-import-which-to-choose\">browser to Power BI,<\/a> click on &#8220;Upload&#8221;. You can check whether the transfer is successful by selecting the Data section on the left-hand side of the screen.<\/p><p>The data is now ready for viewing. Go to the report section to create a waterfall chart from the data. Complete the category, breakdown and value fields.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-10f40dd e-flex e-con-boxed e-con\" data-id=\"10f40dd\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-30da6ec elementor-widget elementor-widget-heading\" data-id=\"30da6ec\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How to master Power BI<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-75fbbfa elementor-widget elementor-widget-text-editor\" data-id=\"75fbbfa\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The waterfall graph is just one of the many <strong>DataViz features in Power BI<\/strong>. This formidable tool not only offers a wide range of visualization options, but also the ability to analyze data from multiple sources to generate reports and dashboards.<\/p><p>The Power BI platform is increasingly used in business, and mastering it is a sought-after skill. To acquire this expertise, you can choose DataScientest.<\/p><p>Our Power BI certification course enables beginners to master the software in just 38 hours spread over five days. Depending on your level, you can also choose to get started in three days, or to study only the more advanced functions over two days.<\/p><p>This course covers not only DataViz, but also the Power Query search engine and the <strong>DAX language.<\/strong> By the end of the course, you&#8217;ll be able to harness the full power of Power BI.<\/p><p>As a Microsoft Learning Partner, DataScientest prepares and administers the Microsoft PL-300 certification exam. Successful completion of this exam leads to <strong>Power BI Data Analyst Associate certification.<\/strong><\/p><p>This training is entirely distance learning via the Internet, and can be financed via different funding options. Don&#8217;t wait any longer, and discover DataScientest to learn how to use Power BI!<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-88b3f99 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"88b3f99\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Discover our Power BI training<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a5a40bb e-flex e-con-boxed e-con\" data-id=\"a5a40bb\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-927809a elementor-widget elementor-widget-html\" data-id=\"927809a\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [{\n    \"@type\": \"Question\",\n    \"name\": \"What is a Power BI waterfall graph?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"In nature, a waterfall very rarely flows in a perfectly steep uniform manner. Before joining the river, waterfalls cross the hollows and reliefs of the eroded cliff.\nThe same applies to the data passing from an initial value to a final value. That's why Power BI's cascade chart has this colorful name, as it shows each individual component contributing to the final value.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"When to use a cascade chart?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"The waterfall chart is used for very specific use cases, particularly in finance. To visualize value changes, there's really no alternative to the Power BI waterfall diagram.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"Waterfall chart and bar chart: what's the difference?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"A bar or column chart shows the total value of a measure in each category using bars. Each bar has a zero baseline.\nA waterfall diagram, on the other hand, shows positive and negative changes in a value. It therefore has a start bar and an end bar, each with a zero baseline\".\n    }\n  }]\n}\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>The Power BI waterfall chart is a type of DataViz that visualizes changes between an initial value and a final value. Find out all you need to know about this graph: presentation, benefits, tutorial, training&#8230; To visualize data, bar and column charts are ideal for initial and final values. However, this type of diagram doesn&#8217;t [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":176524,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2425],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Power BI waterfall chart: Overview and use cases<\/title>\n<meta name=\"description\" content=\"Explore the world of Power BI waterfall charts with our comprehensive guide. Understand the ins and outs of this visualization tool...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/power-bi-waterfall-chart-overview-and-use-cases\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power BI waterfall chart: Overview and use cases\" \/>\n<meta property=\"og:description\" content=\"The Power BI waterfall chart is a type of DataViz that visualizes changes between an initial value and a final value. Find out all you need to know about\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/power-bi-waterfall-chart-overview-and-use-cases\" \/>\n<meta property=\"og:site_name\" content=\"DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-16T18:42:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-16T18:46:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2024\/01\/waterfall-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"427\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/power-bi-waterfall-chart-overview-and-use-cases#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/power-bi-waterfall-chart-overview-and-use-cases\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"Power BI waterfall chart: Overview and use cases\",\"datePublished\":\"2024-01-16T18:42:01+00:00\",\"dateModified\":\"2024-01-16T18:46:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/power-bi-waterfall-chart-overview-and-use-cases\"},\"wordCount\":1118,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Data Science\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/power-bi-waterfall-chart-overview-and-use-cases#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/power-bi-waterfall-chart-overview-and-use-cases\",\"url\":\"https:\/\/datascientest.com\/en\/power-bi-waterfall-chart-overview-and-use-cases\",\"name\":\"Power BI waterfall chart: Overview and use cases\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2024-01-16T18:42:01+00:00\",\"dateModified\":\"2024-01-16T18:46:58+00:00\",\"description\":\"Explore the world of Power BI waterfall charts with our comprehensive guide. Understand the ins and outs of this visualization tool...\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/power-bi-waterfall-chart-overview-and-use-cases\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Power BI waterfall chart: Overview and use cases","description":"Explore the world of Power BI waterfall charts with our comprehensive guide. Understand the ins and outs of this visualization tool...","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/datascientest.com\/en\/power-bi-waterfall-chart-overview-and-use-cases","og_locale":"en_GB","og_type":"article","og_title":"Power BI waterfall chart: Overview and use cases","og_description":"The Power BI waterfall chart is a type of DataViz that visualizes changes between an initial value and a final value. Find out all you need to know about","og_url":"https:\/\/datascientest.com\/en\/power-bi-waterfall-chart-overview-and-use-cases","og_site_name":"DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2024-01-16T18:42:01+00:00","article_modified_time":"2024-01-16T18:46:58+00:00","og_image":[{"width":768,"height":427,"url":"https:\/\/datascientest.com\/en\/files\/2024\/01\/waterfall-1.png","type":"image\/png"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/power-bi-waterfall-chart-overview-and-use-cases#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/power-bi-waterfall-chart-overview-and-use-cases"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"Power BI waterfall chart: Overview and use cases","datePublished":"2024-01-16T18:42:01+00:00","dateModified":"2024-01-16T18:46:58+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/power-bi-waterfall-chart-overview-and-use-cases"},"wordCount":1118,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Data Science"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/power-bi-waterfall-chart-overview-and-use-cases#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/power-bi-waterfall-chart-overview-and-use-cases","url":"https:\/\/datascientest.com\/en\/power-bi-waterfall-chart-overview-and-use-cases","name":"Power BI waterfall chart: Overview and use cases","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2024-01-16T18:42:01+00:00","dateModified":"2024-01-16T18:46:58+00:00","description":"Explore the world of Power BI waterfall charts with our comprehensive guide. Understand the ins and outs of this visualization tool...","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/power-bi-waterfall-chart-overview-and-use-cases"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/176521"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=176521"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/176521\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/176524"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=176521"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=176521"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=176521"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}