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.
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
Solved! Go to Solution.
@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.
thanks ... got it in one.
I'd been to that panel but not picked the subtlety of what I was looking at ... to many visuals on the page!
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |