Advanced Top N Filtering - Keeping Consistency Based on Date Filters

[mramstead1]

Hello All,

I am continuing work on a workload model for my company. On some of my visuals, I am tracking the top 10 activities of an individual based on a certain time period. Here's the filter criteria:

This filter works great when I am looking at an individual's activities over the whole time period, shown below:

My issue occurs when I use the Multi-Row Card to the left of the graphic to sort the visual by a specific month. The visual keeps the criteria it determined based on TOTAL activities, rather than readjusting the top 10 when I select a specific month. Example below (CERT should be excluded from the visual in the month of March and replaced by somthing else, since this individual did none of that activity in March):

I was wondering if there is a way to use the card, or something similar, to change the dates of the data, while also adjusting what is shown on the visual? If not, it almost seems pointless to keep the month filtering in if I can't see the top 10 activities per month.

I look forward to hearing the community's suggestions!

[johnt75 · Accepted solution]

Replace your multi-row card visual with a slicer on the Year Month column. That will filter the column chart to just the chosen month.