Forum Discussion

NewbieJono's avatar
NewbieJono
Post Partisan
4 years ago
Solved

Pop out filter menu

Hello i have a pop out filter menu, created with bookmarks.

 

is there a method i could display in text what filters are selected. When the pop out menu is closed there is no way of telling what filters are applied to my report!

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi NewbieJono ,

     

    You could use CONCATENATEX() to combine all selections:

    Selections = CONCATENATEX( ALLSELECTED('Table'[Category]),'Table'[Category],",")

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi NewbieJono ,

     

    You could use CONCATENATEX() to combine all selections:

    Selections = CONCATENATEX( ALLSELECTED('Table'[Category]),'Table'[Category],",")

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi NewbieJono ,

     

    Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

     

    Best Regards,
    Eyelyn Qin