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
badger123
Resolver I
Resolver I

Slicer question

Hello,

 

I'm using a line chart visual with fields below. I want to be able to keep a specific brand (brand one) in the line chart at all times and add other brands (to compare) from a slicer. I don't want brand one to be in the slicer but I want it to stay in the line chart when other brands from the slicer are selected.

 

How can I achieve this??

 

Capture.PNG

 
 
4 REPLIES 4
v-easonf-msft
Community Support
Community Support

Hi ,  @badger123

Could you please tell me whether your problem has been solved?
If it is,  please mark the helpful replies or add your reply as Answered to close this thread.

 

Best Regards,
Community Support Team _ Eason

AlexisOlson
Super User
Super User

You probably want to use two measures then (and take Brand off of the Legend). One that is statically defined for a particular brand and one that is dependent on the slicer.

Thanks @AlexisOlson ! With this approach would I be restricted to comparing with only one other brand at a time? 

Yes, although it's possible there might be workarounds with more measures and more slicers.

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.