Forum Discussion
Help with Slicer
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.
Yes it will, here's a mockup of that:
And the field well if needed:
4 Replies
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.
Yes it will, here's a mockup of that:
And the field well if needed: