Forum Discussion
waterfall
Hello, I have a table that has a total cost row for each month. I also have components that make up this cost. So let's say costs A,B,C all make total cost D. What I would like to see is a water...
HI Cour002,
According to your description, you mean your table has total rows so it should similar as pivot table, right?
If that is a case, I think it not a valid table for power bi, it will get wrong result when you used to create waterfall or other visuals with summary fields.
For your scenario, I'd like to suggest you to remove these total rows and write a measure to calculate total amount of each level.
Regards,
Xiaoxin Sheng