Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to keep slicer visible?

I have built a dashboard with several pages that are set up the same way. On one of them, the year filter/slicer disappears when you click on the pie chart that the slicer is connected to. I have tried sending the pie chart to the back and the slicer to the front, but it still happens. I built the other slicers/pie charts the same way and it does not happen with the others.

 

Any ideas for how I can get the slicer to stay visible while the pie chart is selected?

 

For reference, the problem is on page five of the Power BI project on this page: https://www.como.gov/sustainability/

This is how the page is supposed to look, and how it works before clicking on a slice of the pie.Once selecting a section of the pie chart, the year filter disappears.

  • Anonymous's avatar
    Anonymous
    3 years ago

    I did figure out how to fix it- I shrunk the pie charts so that the edge of the filer is just barely to the right of the pie chart. I don't know why bringing the filter forward didn't work. I have used this project for a couple of years, and I think this issue just popped up and I'm not sure why. But for now this is working!

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    I did figure out how to fix it- I shrunk the pie charts so that the edge of the filer is just barely to the right of the pie chart. I don't know why bringing the filter forward didn't work. I have used this project for a couple of years, and I think this issue just popped up and I'm not sure why. But for now this is working!

  • DOLEARY85's avatar
    DOLEARY85
    Resident Rockstar

    Hi,

     

    Check the format ribbon, click on the slicer and then bring the slicer to the front:

     

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks for your answer-I had tried that prior to posting this, and for some reason that is not working on this particular page.

  • Try the following: 

    (A) You can turn off the background on your pie chart under Format>General>Effects>Background. This way it'll be transparent and the slicer will always show. 

    (B) Ensure the layer order of the slicer is above the pie chart

    • Anonymous's avatar
      Anonymous
      Not applicable

      Turning the background off does keep the slicer visible, but then it won't let me select a different year after I have selected the pie chart. Is it worth trying to completely rebuilt the page?