Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
newbie2bi
New Member

Trend Analysis

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
1 REPLY 1
Anonymous
Not applicable

HI

Perhaps, this could help you

JamesFr06_0-1657142236870.png

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors