Forum Discussion
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:
| 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
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
- samratpbi
Super User
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
Helper I
That worked perfectly - thank you!