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