Forum Discussion
Solved
Power BI Matrix
I have a matrix in Power BI and it has rows that should be combined into one entry. How can I combine the Application/Processing row with the Application/ Processing row? Is there a way to do this wi...
Hi MEJE
In Power Query you can click on one of the values and replace them with the other. Which one to retain is up to you.
You can do the same for any other values. However, if you expect for new values to have a similar case in the future, you can try replace "/ " with "/" assuming that there won't be another "/" somewhere else in the text.
Go to Transform Data:
- Select the column
- Use:
- Transform → Format → Trim
- Transform → Format → Clean
Thank you for your response. This does not seem to work for me as all of the options are grayed out and I am unable to select anything when I am in the Transform section.