Display Selected Fiscal Years on Chart within Groups

[ahiemstra]

There may be a simple solution for what I’m trying to do however I’m coming up empty.

I have a dataset which is structured like this:

Date	Team	Program
01-Apr-2021	Team C	Mindfulness for Anxiety and Depression
01-Apr-2021	Team A	Mindfulness for Stress
03-Apr-2021	Team D	Mindful Eating: Exploring the 'Whys' of Eating
04-Apr-2021	Team C	Mindful Eating: Exploring the 'Whys' of Eating
05-Apr-2021	Team D	Mindful Eating: Exploring the 'Whys' of Eating

Each row represents a referral.

I would like to create a bar chart which displays the count of referrals by team for each fiscal year selected in a slicer. In my sample report, you can see on Page 1, the chart has the various teams along the x-axis and the y-axis is displaying a sum of referrals for all fiscal years selected in the slicer. This was where I started.

On Page 2, I have the fiscal years along the x-axis and the referrals by team on the y-axis.

Essentially, I want to ‘take parts’ of each and create a chart which looks like this:

Teams plotted on the x-axis and the sum of referrals for each team for each fiscal year selected in the slicer plotted on the y-axis.

Also, ideally, the chart would be dynamic such that if I were to deselect one of the fiscal years in the slicer, the chart would update to only show those selected. For example, if I deselected 2021/22, the chart would update to look like this:

Is what I’m looking for possible?

Sample pbix file can be found here: https://ln5.sync.com/dl/02c25e090/7shjyrmk-s6w6etj9-ay8wnch9-hwy4nhjz

[samratpbi · Accepted solution]

Hi,

you can use the fiscal year column your in Legends section of your visual. Below is the result when I used it. Also change the column chart type to Clustered Column chart, instead of Stacked.

If this resolves your problem, then please mark it as solution, Thanks!

[ahiemstra]

That worked perfectly - thank you!