Skip to main content
cancel
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.

Reply
ASG1512
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 !!

1 REPLY 1
lbendlin
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 https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

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

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.