Trend Analysis

[newbie2bi]

Hi Guys,

Asking the community for help, I've a coloumn which has inconsitent data however it has keywords which i'll be using in the "cards" for visualization such as "ABC" and "XYZ". So when I click on the card "ABC" the "clustered bar chart" should change according to the data and show the trend.

I was thinking to seperate the column with all "ABC" in one column and "XYZ" in another" however I am finding it impossible to do it as has 20k+ rows and too many words/letter/delimiters in between "ABC" and "XYZ". Sample data is below

Can you guys help please?  Any help is greatly appreciated.

Margins 

ABC

10days ABC

XYZ

64 minutes ABC

Remote work

Internal Job ABC

External Job XYZ

ABC half 2020

New postpaid work

[Anonymous]

HI

Perhaps, this could help you

srting_carac = SWITCH(TRUE(), CONTAINSSTRING(Feuil1[Column1],"ABC"),"ABC", CONTAINSSTRING(Feuil1[Column1],"XYZ"),"XYZ",CONTAINSSTRING(Feuil1[Column1],"*"),"Other")