Forum Discussion
Help with Slicer
Yes it will, here's a mockup of that:
And the field well if needed:
Optimally, you should take a look at your data structure to better support this. Something like this would make building a visual like this much easier:
| Period | Business Unit | Amount Type | Amount |
| Oct-24 | IHSD | Actual | 99.85 |
| Oct-24 | IHSD | Budget | 108.04 |
| Oct-24 | IPS | Actual | 60.49 |
| Oct-24 | IPS | Budget | 61.79 |
Then, you'd need 1 measure such as:
Total Amount =
CALCULATE(SUM(Amount))
Then for your X-Axis you'd enter in Period first then Amount Type second, with Business Unit in the legend. Then adding in a slicer for Business Unit will enable filtering the data by an individual business unit easier.
Will this still allow for the structure that I have with my chart with the stacked columns side by side under one month?
Yes it will, here's a mockup of that:
And the field well if needed:
Thanks so much that was a huge help! One question remaining and maybe I am just being dumb abou tthis, but how would I create a measure to calculate the variance between Actuals and Budget per month?