https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Trend-Analysis/m-p/2605300#M4638 <P>Hi Guys,</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>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</P><P>&nbsp;</P><P>Can you guys help please?&nbsp; Any help is greatly appreciated.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>Margins&nbsp;</P><TABLE><TBODY><TR><TD>ABC</TD></TR><TR><TD>10days ABC</TD></TR><TR><TD>XYZ</TD></TR><TR><TD>64 minutes ABC</TD></TR><TR><TD>Remote work&nbsp;</TD></TR><TR><TD>Internal Job ABC</TD></TR><TR><TD>External Job XYZ</TD></TR><TR><TD>ABC half 2020</TD></TR><TR><TD>New postpaid work</TD></TR></TBODY></TABLE> Tue, 28 Jun 2022 00:59:00 GMT newbie2bi 2022-06-28T00:59:00Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Trend-Analysis/m-p/2605300#M4638 <P>Hi Guys,</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>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</P><P>&nbsp;</P><P>Can you guys help please?&nbsp; Any help is greatly appreciated.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>Margins&nbsp;</P><TABLE><TBODY><TR><TD>ABC</TD></TR><TR><TD>10days ABC</TD></TR><TR><TD>XYZ</TD></TR><TR><TD>64 minutes ABC</TD></TR><TR><TD>Remote work&nbsp;</TD></TR><TR><TD>Internal Job ABC</TD></TR><TR><TD>External Job XYZ</TD></TR><TR><TD>ABC half 2020</TD></TR><TR><TD>New postpaid work</TD></TR></TBODY></TABLE> Tue, 28 Jun 2022 00:59:00 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Trend-Analysis/m-p/2605300#M4638 newbie2bi 2022-06-28T00:59:00Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Trend-Analysis/m-p/2623421#M4653 <P>HI</P><P>Perhaps, this could help you</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JamesFr06_0-1657142236870.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/744111i67F254F2BC7960B5/image-size/medium?v=v2&amp;px=400" role="button" title="JamesFr06_0-1657142236870.png" alt="JamesFr06_0-1657142236870.png" /></span></P><DIV><DIV><SPAN>srting_carac = </SPAN><SPAN>SWITCH</SPAN><SPAN>(</SPAN><SPAN>TRUE</SPAN><SPAN>(), </SPAN><SPAN>CONTAINSSTRING</SPAN><SPAN>(</SPAN><SPAN>Feuil1[Column1]</SPAN><SPAN>,</SPAN><SPAN>"ABC"</SPAN><SPAN>),</SPAN><SPAN>"ABC"</SPAN><SPAN>, </SPAN><SPAN>CONTAINSSTRING</SPAN><SPAN>(</SPAN><SPAN>Feuil1[Column1]</SPAN><SPAN>,</SPAN><SPAN>"XYZ"</SPAN><SPAN>),</SPAN><SPAN>"XYZ"</SPAN><SPAN>,</SPAN><SPAN>CONTAINSSTRING</SPAN><SPAN>(</SPAN><SPAN>Feuil1[Column1]</SPAN><SPAN>,</SPAN><SPAN>"*"</SPAN><SPAN>),</SPAN><SPAN>"Other"</SPAN><SPAN>)</SPAN></DIV></DIV> Wed, 06 Jul 2022 21:17:35 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Trend-Analysis/m-p/2623421#M4653 Anonymous 2022-07-06T21:17:35Z