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.
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 Column
Column =
SUBSTITUTE(
TRIM([Category]),
"/ ",
"/"
)
TRIM([Category]),
"/ ",
"/"
)
Then use new Column in your matrix instead.
Thank you for your response. This does not seem to work for me but I will try again to see if I am missing something.
