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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Line chart with measures - Legend showing items filtered out by slicer

Hi there, I have a line chart with a number of different calculated measures.

 

The chart is controlled by a slicer. When using the slicer, the data/lines correct filter out when the apporpriate slicer is selected; however the legend items remain for of the data. 

 

This means I have heaps of legend items for data that isn't shown in the chart. 

 

Has anyone come across this and have a solution? Thanks 

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , How you have implemented it. Like measure slicer, one measure at a time. Or each measure read the slicer value and hide and show based on that.   In the second case, you will legend of measure. In the first case, it should go away.

 

measure slicer
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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