I have a tab with a 'Slicer' and a 'Table' both showing the 'Fiscal Year' field from a DateKey table.
Both visuals display a partial list of the 'Fiscal Year' values defined in the table. Adding (by copy/paste) the same visual to another tab shows the correct full list. Removing and recreating the visual on this tab shows a 'filtered' list. Changing the visual type between types (slicer/table/multi-line card etc.) does not change the results.
When hovering over the filter icon in the top-rigth the pop-up indicates a Filter is affecting this visual. The mystery is that there are no filters or slicers defined.
At one point in the life of this report/dashboard there were 'Synced Slicers' in play, but these have all been removed or deactivated. It really feels like there is one still active but I can't find it.
The same behaviour is evident on each of 3 tabs that were duplicated from an original.
Closing and opening the files; refreshing the data have all NOT helped.
Any ideas or suggestions much appreciated.
Paul
@paulcinoz can you check if there is any slicer which is not visible and that might be the root cause.
- goto view
- click selection pane
it will list everything on the page, make sure there is no slicer whcih is hidden.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@paulcinoz can you check if there is any slicer which is not visible and that might be the root cause.
- goto view
- click selection pane
it will list everything on the page, make sure there is no slicer whcih is hidden.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Helpful resources
Power BI Monthly Update - March 2025
Check out the March 2025 Power BI update to learn about new features.
Fabric Community Update - March 2025
Find out what's new and trending in the Fabric community.
