Actual VS Budget Comparison with Prior Years History.
The complication I have here is that I have a set of “Actual Data” and a set of “Budget Data” in two different tables.
I am using the disconnected table trick so that I can use a slicer to select between various metrics in the same visual.
Example: Table showing volume YOY. I can use a slicer and press “Revenue” and the table will automatically change to display revenue.
Currently I have to use two different slicers in order to change the “Actual Data” and the “Budget Data”.
Obviously if these get out of sync it can be a huge variance.
Is there a way to “link” these slicers together? They are named identically but link back to different source data.