Waterfall Chart need to down bar and up with positive value

[Thennarasu_R]

Hi all !

I need one help from waterfall chart . I have 8 category with all being positive only.

What my quereis is First will show down and other category will show up . Default waterfall chart show only up hierarchies only .

But i want below mention screen shot

Thanks,
Thennarasu 

[v-yiruan-msft]

Hi @Thennarasu_R ,

Waterfall charts in Power BI show a running total as values are added and subtracted. These charts are useful for understanding how an initial value is affected by a series of positive and negative changes. If you want to show down bar and up with positive value in waterfall visual when only have the positive values, you need to add a dummy category with a negative value to the data. The detailed steps as below:

Waterfall charts in Power BI - Power BI | Microsoft Learn

1. Add a new column to your data table and name it "Dummy Category".
2. Fill the column with a negative value, such as -0.1.
3. Add the "Dummy Category" column to the Category bucket in the Waterfall visual.
4. Hide the "Dummy Category" column from the visual.

Best Regards