Waterfall Chart -Two Category

Hi,

Creating a Waterfall Chart in Power BI for weekdays with both demand and supply categories is challenging since the standard chart handles only one measure per category. To address this, you can create a combined measure that allows for representation in a waterfall chart.
Please follow the following steps:

• Select the Demand and Supply columns.
• Use the "Unpivot Columns" feature to transform these into two rows per weekday (one for demand and one for supply), resulting in a new attribute column (e.g., "Category" with values 'Demand' and 'Supply') and a value column.
• Create New Measure as follows
• Net Effect = SUM(Data[Supply]) - SUM(Data[Demand])
• From the Visualizations pane, select the Waterfall Chart icon.
  
  • Axis (Category): Drag the Weekday field here.
  • Values: Drag the Net Effect measure here.
  • Optionally, adjust the colors and formatting to distinguish between positive and negative values (supply and demand).
  • The Waterfall Chart will now display the net effect (supply minus demand) across the weekdays.
  • If you need to show both demand and supply separately, you might have to consider a different type of chart or look for custom visuals in the Power BI marketplace, as standard Waterfall Charts are primarily designed for cumulative values.