Forum Discussion

Pikachu-Power's avatar
Pikachu-Power
Icon for Impactful Individual rankImpactful Individual
5 years ago
Solved

multiple information in one cell

Hello,   i need some idea how to handle multiple information in one cell 🙂 I have the follwing table and want to see the final result:     I need a Filter with the group entries and dynam...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Pikachu-Power ,

     

    You could create a table contains the split groups and use it as slicer.

    Then create a measure as below and filter the blank rows.

    Measure = IF(CONTAINSSTRING(SELECTEDVALUE('Table'[group]),SELECTEDVALUE(slicer[group])),SELECTEDVALUE(slicer[group]),BLANK())

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Pikachu-Power ,

 

You could create a table contains the split groups and use it as slicer.

Then create a measure as below and filter the blank rows.

Measure = IF(CONTAINSSTRING(SELECTEDVALUE('Table'[group]),SELECTEDVALUE(slicer[group])),SELECTEDVALUE(slicer[group]),BLANK())

 

Best Regards,

Jay

Pikachu-Power's avatar
Pikachu-Power
Icon for Impactful Individual rankImpactful Individual
5 years ago

Nice idea! Thank you.