multiple information in one cell

[Pikachu-Power]

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 dynamic group column in the final matrix (see example where B is filtered).

I tried to create a separate table like

Measure_Selection =

DATATABLE (

"Measure",STRING,

"Order",INTEGER,

{

{ "A",1 },

{ "B",2 },

{ "C",3 }

}

)

but than it is not possible to use a measure as a column.

With

A = IF(ISBLANK(SEARCH("A", Table[Group], 1, BLANK())), BLANK(), "A")

it would be possible to extract A in a new column but didnt helped. 

many thanks for ideas.

[Anonymous · Accepted solution]

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]

Nice idea! Thank you.

[amitchandak]

@Pikachu-Power , is it possible to break his information into rows, using split by a delimiter in power query?

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

[Pikachu-Power]

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?