Problem with Filter/Slicer to filter by text

[Anonymous]

Hello Community!

I ran out of ideas to filter my content in Power BI, maybe you can help. It would be much appreciated!

I prepared a sample. I have a dashboard on companies, that is filtered by "company" slicers. I want to include tagged articles regarding companies in my dashboard. There is always a leading "Tag A" and a related, describing "Tag A.n". The third Tag is always a companies name.

Since the tags are exported, I have no influence of the order of their listing, which leads to my problem:

 I cannot use "text to column" to create a company column (last column), because it is not guranteed that the company tag always comes last.  Sample below.

Tags,Article Titles,Tier 1 Tag,Tier 2 Tag,Company

TAG A,TAG A.1,Company A	aidhiadiaiadbniasbn	TAG A	TAG A.1	Company A
TAG A,TAG A.1,Company A	aidhiadiaiadbniasbn	TAG A	TAG A.1	Company A
TAG A,TAG A.1,Company A	aidhiadiaiadbniasbn	TAG A	TAG A.1	Company A
TAG A,TAG A.1,Company A	aidhiadiaiadbniasbn	TAG A	TAG A.1	Company A
TAG A,TAG A.1,Company A	aidhiadiaiadbniasbn	TAG A	TAG A.1	Company A
TAG A,TAG A.1,Company A	aidhiadiaiadbniasbn	TAG A	TAG A.1	Company A
TAG A,TAG A.1,Company A	aidhiadiaiadbniasbn	TAG A	TAG A.1	Company A
TAG A,TAG A.1,Company A	aidhiadiaiadbniasbn	TAG A	TAG A.1	Company A
TAG A,TAG A.1,Company A	aidhiadiaiadbniasbn	TAG A	TAG A.1	Company A
TAG A,TAG A.1,Company A	aidhiadiaiadbniasbn	TAG A	TAG A.1	Company A
TAG A,Company B,TAG A.1	aidhiadiaiadbniasbn	TAG A	Company B	TAG A.1
TAG A,Company B,TAG A.1	aidhiadiaiadbniasbn	TAG A	Company B	TAG A.1
TAG A,Company B,TAG A.1	aidhiadiaiadbniasbn	TAG A	Company B	TAG A.1
TAG A,Company B,TAG A.1	aidhiadiaiadbniasbn	TAG A	Company B	TAG A.1
TAG A,Company B,TAG A.1	aidhiadiaiadbniasbn	TAG A	Company B	TAG A.1
TAG A,Company B,TAG A.1	aidhiadiaiadbniasbn	TAG A	Company B	TAG A.1

I tried to create relationships in Power BI for multiple columns ("Tier 1 Tag", "Tier 2 Tag", "company") and "company" columns of different sources/tables, but it will only allow me to activate one of these at a time. 

Manually using the filter pane to set "includes company A" filters is not desireable.

Is there a possibility to use company slicers to search for the terms "company name" in the "Tags" column (first column)? Or do you have any other idead?

Thanks for help

Strixx

[Anonymous · Accepted solution]

Hi @Anonymous ,

Do you want to extract the company id from the Tags column?

If you do, please try this calculated column. It first gets the location of the company, and then intercepts the company id through the LEFT and RIGHT functions.

Company = RIGHT(LEFT([Tags],FIND("Company",[Tags])+8),1)

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hello Stephen,

firt of all thanks for your reply! Creative solution, but not what I need, if i understood it correctly.

I think my sample data was confusing here. 

In my real data there will only be the company name given, there is no indicator like company followed by the ID or the name. 

This is more realistic sample data:

Computer (Tag 1), Software (Tag 2), Microsoft (company)

Smartphone (Tag 1), Apple (company), Operating System (Tag 2)

I do have a list of all companies that can appear, if that helps. Like, could i use the find-function to extract company names by feeding it all the company name items?

Thanks again and have a nice weekend

[croberts21]

In order to use Power BI correctly, your data must be in the same format. I.e. the company must always be in the same column. I don't see any solution to this. Perhaps someone else will think of something. 

One option is to manually fix the data so the company is always in the same column before you send it to PBI. 

[Anonymous]

Thank you for your response, i was afraid of that this will be the case. Manually typing the comapny into the same column would be too much of an effort.

I might have to try a workaround with some auxiliary tables. Or look into the Bot for smarter scraping.

[Anonymous]