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.

Hi bansag2 ,

I'm sorry, but it's true that you can only place one value in the waterfall chart officially provided by Microsoft, which is limited by the design of the waterfall chart itself. If you are trying to compare the difference between SUPPLY and DEMAND, then you can choose to use MEASURE to do the calculations and then put the MEASURE into the graph.

Also I don't understand your sentence "and the current stock measure to the Starting Value field", there is no such field in the official waterfall chart provided by Microsoft, may I ask which waterfall chart you are using?

If it's custom visual, then I'm sorry that I may not be able to provide you with technical support, as custom visual has no official documentation for a specific introduction.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.