Project dashboard

[Anonymous]

Hi - I am attempting to create a dashboard that allows a user to compare the company value in each region with a stacked column chart. I've attached an image of what I am trying to do from an Excel worksheet. My data is in the same form as columns A-C, columns O-P are supposed to illustate two slicers and the charts show before and after the entries in the slicers are selected. So to summarise the two features:
1. using a slicer allowing the user to add potential future projects, increasing value in respective region.
2. In addition, I would like to add another slicer for hedges that would reduce the existing company value by the amount of the hedge in a specific region and add the value of the hedge on top of the stacked graph.
So far, with help from someone else on this forum, I have been able to do something like what was explained in this link here:
https://community.powerbi.com/t5/Desktop/Is-there-a-way-to-only-apply-a-filter-on-a-specific-subset-...

I guess my problem is that when selecting the Hedges via the slicer, I would like the total value of Operational to be reduced by the total value of the selected Hedges, then have the absolute value of the Hedges stacked on top of the Operational value (like Region E below).
Hope this makes sense

[Anonymous · Accepted solution]

Hi @Anonymous ,

So you want to get the reverse of selected value and display on the total side?
If this is a case, I'd like to suggest you use values and except function to get the reverse of selected value, then you can simply do aggregate and absolute on these values.

DAX EXCEPT function 

If you confused about coding formula, please share some dummy data with a similar data structure for test.

Regards,

Xiaoxin Sheng