Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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,...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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.

v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

 

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.

 

 

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