Forum Discussion

ahiemstra's avatar
ahiemstra
Icon for Helper I rankHelper I
2 years ago
Solved

Display Selected Fiscal Years on Chart within Groups

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:

 

DateTeamProgram
01-Apr-2021Team CMindfulness for Anxiety and Depression
01-Apr-2021Team AMindfulness for Stress
03-Apr-2021Team DMindful Eating: Exploring the 'Whys' of Eating
04-Apr-2021Team CMindful Eating: Exploring the 'Whys' of Eating
05-Apr-2021Team DMindful 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

  • 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!

2 Replies

  • 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!