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

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

hi amitchandak,

you mean to split by a delimiter into columns and via pivot into rows? i was thinking about that but we would have to much rows than. with for example 100000 datasets and in avarage 3 group elements we would have 300000 datasets.

 

Is it may possible to create additional columns via delimiter with only A, B or C entries and control these via the Measure_Selection Table?