Forum Discussion
Custom format text data
you may have to create a custom transformation steps in power query to convert the original column values to the desired format. Out of the box custom format like in excel is not available in power bi afaik.
If the format is consistent and you can put a logic into it, you can probably transform it in power query, for example... insert a '/' at position 3 and a '-' in position 5.
ABCDE > AB/C-DE
https://learn.microsoft.com/en-us/powerquery-m/text-functions
you may have to create a custom transformation steps in power query to convert the original column values to the desired format. Out of the box custom format like in excel is not available in power bi afaik.
Thanks for the response, can you elaborate a little more? I don't know how to do custom transformation steps in power query.
If the format is consistent and you can put a logic into it, you can probably transform it in power query, for example... insert a '/' at position 3 and a '-' in position 5.
ABCDE > AB/C-DE
https://learn.microsoft.com/en-us/powerquery-m/text-functionsthank you!