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

Get Fabric certified for FREE! Don't miss your chance! Learn more

Reply
kadirkkkk2
Frequent Visitor

Define a bar or pie chart to be work as a slicer

Sometimes we need slicers to show more info so do bar and pie charts has both number, colors and size.

There some of them in market but they are lack of formatting options and they are not free. 

 

It'ld be so helpful to turn a visual from normal state to work like a slicer.


As a slicer i need,

* To filter other slicers

* To not lose selected option even i select or click other visual

 

2 ACCEPTED SOLUTIONS
cengizhanarslan
Super User
Super User

You can’t fully turn a bar or pie chart into a real slicer in Power BI.

 

Charts can filter other visuals and slicers (via Edit interactions), so that part already works.
But charts cannot keep their selection once you click somewhere else, only slicer visuals have persistent selection behavior.

 

There is no setting to make a chart behave exactly like a slicer.

 

Best practical workaround:Use a real slicer for selection (can be small or hidden) and keep the bar/pie chart only for display. Both use the same field, so the slicer controls filtering, and the chart shows numbers, colors, and size.

 

Bookmarks can simulate this, but they don’t scale well and aren’t dynamic.

___________________________________________________________________________________________________________________________________
If this helped, ✓ Mark as Solution | Kudos appreciated
Connect on LinkedIn | Follow on Medium
AI-assisted tools are used solely for wording support. All conclusions are independently reviewed.

View solution in original post

Olufemi7
Solution Supplier
Solution Supplier

Hi @kadirkkkk2, great idea.

While Power BI doesn’t have a one‑click “turn a chart into a slicer” feature, you can get almost the same experience using built‑in capabilities, and keep selections persistent.

Here’s how: 

1) Use chart interactions to filter the page (slicer lists will also narrow)

  • Select your chart → Format → Edit interactions → set other visuals to Filter (instead of Highlight).
  • This makes your bar/pie behave like a controller for the rest of the page.
    Docs:
  • Visual interactions (cross‑filter & cross‑highlight): How visuals cross-filter each other in a Power BI report 

    Note: Charts can’t directly select slicer items; they filter slicers indirectly by changing the page’s filter context (so slicers show fewer available items, but their “selected value” doesn’t change).
    Docs:

    How visuals cross‑filter each other: How visuals cross-filter each other in a Power BI report 

    2) Make chart selections persistent

    A normal click on a chart is temporary. Use either of these to keep the selection:

View solution in original post

6 REPLIES 6
v-veshwara-msft
Community Support
Community Support

Hi @kadirkkkk2 ,

Just checking in to see if you query is resolved and if any responses were helpful.
Otherwise, feel free to reach out for further assistance.

Thank you.

v-veshwara-msft
Community Support
Community Support

Hi @kadirkkkk2 ,

Thanks for reaching out to Microsoft Fabric Community.

Just wanted to check if the responses provided were helpful.
If further assistance is needed, please reach out.

 

As an additional reference, you may also review the similar discussion where the Attribute Slicer custom visual is mentioned as an alternative that reacts to filter context:
Solved: Re: Is It Possible for Visuals to Control Slicer S... - Microsoft Fabric Community

Thank you.

Olufemi7
Solution Supplier
Solution Supplier

Hi @kadirkkkk2, great idea.

While Power BI doesn’t have a one‑click “turn a chart into a slicer” feature, you can get almost the same experience using built‑in capabilities, and keep selections persistent.

Here’s how: 

1) Use chart interactions to filter the page (slicer lists will also narrow)

  • Select your chart → Format → Edit interactions → set other visuals to Filter (instead of Highlight).
  • This makes your bar/pie behave like a controller for the rest of the page.
    Docs:
  • Visual interactions (cross‑filter & cross‑highlight): How visuals cross-filter each other in a Power BI report 

    Note: Charts can’t directly select slicer items; they filter slicers indirectly by changing the page’s filter context (so slicers show fewer available items, but their “selected value” doesn’t change).
    Docs:

    How visuals cross‑filter each other: How visuals cross-filter each other in a Power BI report 

    2) Make chart selections persistent

    A normal click on a chart is temporary. Use either of these to keep the selection:

cengizhanarslan
Super User
Super User

You can’t fully turn a bar or pie chart into a real slicer in Power BI.

 

Charts can filter other visuals and slicers (via Edit interactions), so that part already works.
But charts cannot keep their selection once you click somewhere else, only slicer visuals have persistent selection behavior.

 

There is no setting to make a chart behave exactly like a slicer.

 

Best practical workaround:Use a real slicer for selection (can be small or hidden) and keep the bar/pie chart only for display. Both use the same field, so the slicer controls filtering, and the chart shows numbers, colors, and size.

 

Bookmarks can simulate this, but they don’t scale well and aren’t dynamic.

___________________________________________________________________________________________________________________________________
If this helped, ✓ Mark as Solution | Kudos appreciated
Connect on LinkedIn | Follow on Medium
AI-assisted tools are used solely for wording support. All conclusions are independently reviewed.
Anand24
Super User
Super User

Hi @kadirkkkk2,
If you are talking about using a bar chart (or any visual except slicer) as a slicer, then

* To filter other slicers - This visual will automatically filter other visuals including your slicer visuals. Only date slicer will not be driven/filtered as a default property of Power BI.

* To not lose selected option even i select or click other visual - AFAIK, default power bi bevahior is to loose the selections in driving visual when you click on other visual(s). You can press on Ctrl key in your keyboard and then select in other visuals to not loose selection.

 

  Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

Proud To Be a Super User !!!
LinkedIn
AntoineW
Super User
Super User

The slicer has the functionnality to filter global elements on the reporting. 

If you need to filter on a specific value on a bar chart/pie chart, you can click on the value of this element and it will highlight others visuals if all your relationship on your semantic model is done correctly.

Helpful resources

Announcements
Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.