Forum Discussion

bhalicki's avatar
bhalicki
Icon for Helper V rankHelper V
1 year ago
Solved

Filter visuals with multiple checkboxes

Hi all, Hoping someone has a better solution.   I have a client who would like to filter a table based on checkboxes.  Each checkbox may have different criteria.  Example below: In the past...
  • v-achippa's avatar
    v-achippa
    1 year ago

    Hi bhalicki,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Power BI cannot use two or more calculation items from the same calculation group at the same time.

    Calculation groups are single select slicer, so they cannot behave like a checklist so every new selection overwrites the previous one. For a true multi select filter you will need a regular slicer that lists every rule.

    So se the disconnected table with boolean flag for each rule and use a measure that checks whether any of the flags chosen in the slicer is TRUE for the current row.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thanks and regards,

    Anjan Kumar Chippa