I'm trying to create a personalized waterfall graph on Power BI, but I can't get the results I expected. I have this data sheet. In Excel it's easy to set the waterfall graph with the 'Define as Total' tool. Data
This is the graph I want to create on Power BI (This one I made on Excel: Waterfall graph
But on Power BI I'm getting this result: Result on Power BI
What I need is the 'Total' and 'Total + Hedge' columns set as a total column, just like the example graph on Excel. Is this possible? I have to change the data sheet?
Cannot use Waterfall visual as you have two total bars. One solution is use Stacked Column visual with assist column of value:
Table data should be:
But color cannot be changed I am afraid.