Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to select 1400 items from my slicer dropdown efficiently?

Hi All, 

 

I have over 1400 items I need to select from my dropdown. Is there an effecient way to do this. I have those source codes in a separate file, so can create a new table, but not sure how to add that as a new group in my slicer thats already set up using the main D_source table. I am also new to DAX, so formulas would be helpful to see if required. 

 

Any and all help is very much appreciated. 

 

Thanks

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Anonymous , If the tables are related or the group is from the same table, just drag it before the item. it will create a hierarchal slicer

     

    you can also explore custom visual text filter, to get a search experience

    Text Filter Slicer and how to search on Multiple columns: https://youtu.be/RbeZRJ3uAZE

     

    The information you have provided is not making the problem clear to me. Can you please explain with an example.

    Appreciate your Kudos.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks for responding. 

     

    In essence - I have a slicer with 10,000 + source codes. From those 10,000 - I need to select 1,400 of them. Just trying to see if there is a more effecient way of doing this. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    any tips based on my message above?