March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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/
Solved! Go to Solution.
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!
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!
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
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?
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 👍
Thanks for your answer-I had tried that prior to posting this, and for some reason that is not working on this particular page.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
114 | |
76 | |
57 | |
52 | |
44 |
User | Count |
---|---|
168 | |
116 | |
63 | |
57 | |
50 |