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

Be 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

Reply
jdt008
Advocate II
Advocate II

Selecting a data element in a Slicer brings you back to the top of the Slicer.

When you scroll and select a data element within a Slicer, the Slicer auto scrolls to the top.  Please advise.  Thanks.

9 REPLIES 9
joe817
Frequent Visitor

I did not see the problem in 2017-June update and earlier, but the problem comes back again in the 2017-July update. I'll use custom visual for now until Microsoft people fix it.

Greg_Deckler
Super User
Super User

This one I do see in the Desktop and it is pretty annoying!!



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Check the data that your Slicer selection is pointing to. I've found this happened to me after importing excel tables. After experimenting and saving the table to CSV files prior to using in BI, Slicer selections remains as is

We are connected to a tabular model for scalability.  We do not work with CSV files.  Thanks.

I don't see this happening on every slicer I create... Can you confirm the same? The behaviour appears to only occur when there are many values to choose from. This is purely speculative, but if you watch the size of the gray box in the scroll bar on the right, it will blink and change shape after you reach a certain point (probably adjusting to the amount of data in the slicer). The "jump up" behaviour starts on any selection I make after that occurs. You can repeat the sequence each time by clearing the selections and you will notice the grey bar resizes again.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Eno , that could be it , I can easily test that, when I filtered my Slicer dates to 2 years instead of 10, at the time I was having other issues BI issues and never made that correlation.

 

 jdt -seems I'm also working a tabular model, but that really has nothing to do with your problem- I'm playing around with this to find its limitations- I'll look into you problem anyway

The reason for this issue is exactly as Eno stated- See Eno's statement above

 

Experiment Setup- 3 tables, 2 Slicers connected to "Criteria Table", "Unique table", "Results table"

 

I attached 2 Slicers to a "Criteria table", Slicer #1 accessed the data in a general way causing many more choicesto show up  in the Unique table (Unique table is connected to the Results table), Slicer #2 was more specific, data to the "Unique Table" was much less. Slicer #1 gave me results (in the Results Table) when selecting near the top of the Slicer but not below a certain point, that's when the stated problems occured. Slicer 2 caused no issues, there was much less choices in the Slicerto choose from.

 

Therefore Eno is correct

 

 I filtered the data I didnt need just to simplify and ran into this issue only prior to the filter. 

 

asHley95e

Soooo, it looks like the next step is to find how Bi responds to split tables- I have a few ideas- anyone done this yet? 

whew, glad I'm probing and not working with live data

Correct, not on every slicer.  And yes, I'm observing the same behavior that you describe. 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.