Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Using multiple values(100+) in a slicer

Hello All,

 

We have a scenario wherein we have multiple end users who want to input 200+ values into a slicer to filter data relevant to them.

 

We are unable to find an option where filter values can be copied to a clipboard and pasted to a slicer to filter the data.

 

Different end users have different combination of filters that they would need to get to the data they are looking for.

 

Please let us know how this can be achieved in Power BI .

 

Thanks

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous,

    I'd like to suggest you add a calculated column to your table to group these records based on your filter conditions.
    Then you can use the field as a filter to simply pick up the range of '100+' values instead of manually selecting them in your filters.

    Regards,

    Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous,

    Any update on your requirement?  Did these suggestions help with your scenario? if that is the case, you can consider Kudo or accept the useful suggestions to help others who faced similar requirements and find it more quickly.

    If these also don't help, please share more detailed information to help us clarify your scenario to test.

    How to Get Your Question Answered Quickly 

    Regards,

    Xiaoxin Sheng