Forum Discussion
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 without having to go back and correcting the source data and then refreshing?
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.
10 Replies
Usually two options,
1. In Power Query, Right-click column, Replace Values 'Application/ Processing' with Application/Processing
2. If you don’t want to touch Power Query, create a Calculated ColumnColumn =
SUBSTITUTE(
TRIM([Category]),
"/ ",
"/"
)Then use new Column in your matrix instead.
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.
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.
