Forum Discussion
Adding Commas to Text
- 2 years ago
Anonymous , I power query use Split by position, multiple times with 3,4,4 and the create columns. If needed append them again
https://learn.microsoft.com/en-us/power-query/split-columns-positions
For visual you can also consider this approach after splitting and combine
Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c
https://medium.com/@amitchandak/power-bi-search-text-parts-in-text-ad2f9783ffa2
Anonymous , I power query use Split by position, multiple times with 3,4,4 and the create columns. If needed append them again
https://learn.microsoft.com/en-us/power-query/split-columns-positions
For visual you can also consider this approach after splitting and combine
Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c
https://medium.com/@amitchandak/power-bi-search-text-parts-in-text-ad2f9783ffa2