Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
mramstead1
Frequent Visitor

Advanced Top N Filtering - Keeping Consistency Based on Date Filters

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:

mramstead1_0-1648485227751.png

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

mramstead1_1-1648485310146.png

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):

mramstead1_2-1648485457889.png

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!

1 ACCEPTED SOLUTION
johnt75
Super User
Super User

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.

View solution in original post

1 REPLY 1
johnt75
Super User
Super User

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.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.