cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
CIAEricDong Frequent Visitor
Frequent Visitor

Slicer - Drop Down list is empty

Hi there

 

Not sure if you guys met this problem, the drop-down list of default slicer in Power BI is empty when clicking it the first time, and it will work normally by clicking it again to close, again to open. So, it's like I have to click it three times to see the drop-down list value.

 

My teammate met the same problem before and no solution. I tested it on another computer, same issue. Published to Power BI service, same issue. I also googled a lot, no similar issue found. 

 

f1.png

 

Close the dropdown list and then open again.

f2.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
CIAEricDong Frequent Visitor
Frequent Visitor

Re: Slicer - Drop Down list is empty

Hey Guys and @v-lid-msft 

 

I managed to solve this problem simply reduce the item font size from 10 to 8. That Simple!

 

And my teammate met the same problem, I asked her to reduce the item font size, you know what? Working like magic.

 

So I think it's just a bug, definitely not my side issue.

 

Anyway, problem solved.

View solution in original post

4 REPLIES 4
Community Support Team
Community Support Team

Re: Slicer - Drop Down list is empty

Hi @CIAEricDong ,

 

I think that maybe the version of your power bi desktop is out-of-date? But in your scenario, your run into the same problem in power bi service, it may be too many rows in this column, you can try to use DISTICT() function and then create a slicer using the new table to test.

 

BTW, the drop down list works well in my Power BI Desktop, and in Power BI Service, it load about one second and show the result as also. My version of Power BI Desktop is 2.72.5556.701 (August 2019) run on Windows10. My version of Power BI Service is 13.0.10599.151 run on chrome.

 

Slicer-Drop-Down-list-is-empty-1.pngSlicer-Drop-Down-list-is-empty-2.png

 

If the issue still occur, kindly share your sample data to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 

Community Support Team _ DongLi
If this post helps, then please consider Accept it as the solution to help the other members find it more

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
CIAEricDong Frequent Visitor
Frequent Visitor

Re: Slicer - Drop Down list is empty

Hi @v-lid-msft 

 

Thanks for the reply. My desktop version is Version: 2.71.5523.821 64-bit (July 2019). Only one month older than yours, I don't think it's the reason. 

 

PBI Service version is Version13.0.10599.151, same as yours.

 

Regarding the rows, I thought that at the first beginning as well, but my "Month" slicer in that screenshot has only 78 rows in that column. 

 

It does have confidential information, so I am not able to share the pbix file with you.

Community Support Team
Community Support Team

Re: Slicer - Drop Down list is empty

Hi @CIAEricDong ,

 

For the issue, I cannot reproduce it here.  We suggest you to open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/

 

Support Ticket (1).gif

 

Community Support Team _ DongLi
If this post helps, then please consider Accept it as the solution to help the other members find it more

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
CIAEricDong Frequent Visitor
Frequent Visitor

Re: Slicer - Drop Down list is empty

Hey Guys and @v-lid-msft 

 

I managed to solve this problem simply reduce the item font size from 10 to 8. That Simple!

 

And my teammate met the same problem, I asked her to reduce the item font size, you know what? Working like magic.

 

So I think it's just a bug, definitely not my side issue.

 

Anyway, problem solved.

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors