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

Dropdown Slicer- Inconsistent Behavior

My users complain about the dropdown slicers in the BI model.

Whenever a dropdown is first expanded, it sows limited results-I believe its always n-1 results for n items.

On subsiquent expansions, it opens fine.

 

I suspect it has something to do with the "select all" option, but I might be wrong.

Dropdown- Initial.JPGDropdown- Second.JPG

Status: New
Comments
v-robertq-msft
Community Support

Hi, @rbriga 

According to the sample picture you posted, it seems that the slicer is probably blocked by the text box, but I didn’t meet this problem when I made a test:

v-robertq-msft_0-1622710368207.png

v-robertq-msft_1-1622710368210.png

 

Therefore, you can post a sample pbix file without the sensitive data with this kind of problem so that we can help you to judge if it’s a bug in advance.

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

abayless
Advocate II

@v-robertq-msft  This is not a problem with @rbriga particular report, this is an issue on the PBI service side once the report is published. This has been reported repeatedly over the last couple weeks by several different users. Its only on the PBI service (not desktop) and it effects every slicer with 2-6 items.

 

My report of the same issue reported that this would be fixed by the end of last month: https://community.powerbi.com/t5/Issues/Small-Drop-Down-Slicers-don-t-expand-fully-on-first-browser/...

 

Another: https://community.powerbi.com/t5/Issues/Slicer-dropdown-not-showing-data/idi-p/1836971

Another: https://community.powerbi.com/t5/Issues/Slicer-dropdown-not-showing-only-one-value-on-first-click/id...