Help with Slicer

[pmccurry55]

I have a chart that has stacked columns containing actuals and budget side by side for each month with multiple business units per column(shown in image). I am just wondering how I can create a slicer that will filter for each business unit(IHSD, IPS, etc) for all months and both actuals and budget? I should mention that I had to make the business units (actuals and Budget per Business unit) as measures.

Been stuck on this for a minute.

[Alex_Sawdo]

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. 

[pmccurry55]

Will this still allow for the structure that I have with my chart with the stacked columns side by side under one month?

[Alex_Sawdo · Accepted solution]

Yes it will, here's a mockup of that: 

And the field well if needed: 

[pmccurry55]

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?