Forum Discussion
Custom column is not filtering table
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.
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.
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.
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.