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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

New Member

Dynamic Legends based on the combination of Slicers an Date Range

Context: A stacked column chart visual which has count of metric on the Y-axis and dates on the X-axis. The chart is displaying Top N regions/territories based on the selection from two slicers


Slicer 1 : Region/Territory

Slicer 2 : Top N (e.g., top 5, 10 or 15) for a given time period (Slicer 3). 


Legend shows a list of Region/Territories as per selection of Slicer 1


Problem Statement : The chart needs have the capability of displaying Top N regions/territories on the basis of selection of slicer 1 and 2, but should do that for the date range of slicer 3 only.


Say, Slicer 3 has a date range of Jan-23 to Mar-23, Slicer 1 = Territory & Slicer 2 = Top 5


So, the chart should display count of metric for Top 5 territories(terr1, terr2, .. terr5) from Jan-23 to Mar-23, now assuming we want to display it at a monthly level, it should display values only for those 5 territories.


Legend should also display only those 5 territories which are part of that Top 5.


Current Scenario:  Everything is done apart from legend requirement.


Please Help !!

Super User
Super User

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to

Please show the expected outcome based on the sample data you provided.

Want faster answers?

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Fabric certifications survey

Certification feedback opportunity for the community.