Custom column is not filtering table

[trupac]

I have a matrix that filters my table.

I added a custom column with this formatted formula 

=Text.Insert(Text.Insert(Text.Insert(Text.Insert(Text.Insert ([WELL_LOCATION],3,"/"),6,"-"),9,"-"),13,"-"),18,"/")

I tried to replace WELL_LOCATION with this new formatted columm but now my table does not filter at all.

[trupac · Accepted solution]

I figured out an alternate way to fix my issue, instead of creating columns or measures in Power Bi, I just wrote the reformatting into my sql code and my tables and visuals all work now. 

[v-kaiyue-msft]

Hi @trupac ,

It seems that you have gotten a solution. Could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards,

Clara Gong

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

[v-kaiyue-msft]

Hi @trupac ,

If you create a new custom column in power query, it will insert specific characters based on the specified position in your original text string [WELL_LOCATION].

So if your original WELL_LOCATION value is like "ABCDEFGHIJKLMNO", it will be converted to "ABC/DE-FG-HIJ-KLMN/O" and it will become the new column.

If you don't need the original column, then you can delete it and only keep the new custom column, and then use the new column for the matrix.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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

[trupac]

Hi Clara,

Thank you for the response, I have tried deleting the original WELL_LOCATION column but it breaks all the relationships to all the tables. I'm just trying to get my table to filter by the formatted column rather than the original and for some reason it won't work. 

[v-kaiyue-msft]

Hi @trupac ,

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

Best Regards,

Clara Gong

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

[ghoshabhijeet]

@trupac  Thank you for your query. Could you please share the pbix file with some sample data ? Thanks!