how to create a slicer from a column with multiple values separated by delimiter

[cindz_za]

Hi All,

I want to create a slicer using a column with multiple statements that flags a transaction ,separated by delimiter for each record.

Is there a way I can create a table that consists of all the unique statement flags such that when I select statement_1 it will return all the transactions that are flagged by statement_1, eg. trans id 1, 3 and 4.

Also when statement_1 is selected it must update all the visuals in the page (flagged transaction vizual must be 3, donut chart must show statement_1 count and the table must show row 1,3 and 4 which are rows that were flagged by statement_1).

The attempt I made as explained in https://community.powerbi.com/t5/Desktop/Filter-table-based-on-two-columns/m-p/318359#M141583 , I created a slicer table forunique statement flags and a measure to use to filter. 

The issue im having is when I use the slicer table i created on a slicer, it does not update the whole vizuals in the page. It only updates the table.

How can I use a slicer for statement flags flagged by transaction field or split statements separated by delimeters?
Is there an alternative vizual I can use that when I select a value on the filter/slicer, all the vizuals will update.

Please see example below, I selected statement_1 on the slicer only the able is updated but the othe vizuals do not update.

The desired output is for all the vizuals to be updated. In this case when Stateent_1 is selected, the flagged transaction card must be 3, th area chart must show the 3 transactions and the donut must show statement_1 percentage and the legends must be statement_1.

I have attached the data I used for this visual as csv file 

trans id	date	client name	amount paid	statement_flag1	statement_flag2	statement_flag3	statement_flag4	total flags per transaction	statement flags that flagged the transactions
1	01/03/2020	abc	$200	statement_1		statement_3	statement_4	3	statement_1; statement_3; statement_4
2	05/04/2020	cdy	$1500		statement_2			1	statement_2
3	11/05/2020	xwy	$10000	statement_1	statement_2	statement_3	statement_4	4	statement_1; statement_2; statement_3; statement_4
4	03/07/2020	lsp	$500	statement_1	statement_2			2	statement_1; statement_2
5	12/10/2020	gyh	$1000			statement_3		1	statement_3

[amitchandak]

@cindz_za , We will either split [statement flags that flagged the transactions] column into multiple rows in power query

or we create a table using this column, then in a new table duplicate this and split it into rows. Join this with original table [statement flags that flagged the transactions] in the model and handle duplicate in measure using values and summarize

[cindz_za]

Hi @amitchandak is it possible if you can show this on pbix file please? Im relatively new to power bi.