Forum Discussion
Power BI Matrix
- 5 months ago
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.
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.
- MEJE5 months agoNew Member
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.
- danextian5 months agoSuper User
Can you please post a screenshot? Note: this has to be done in power query.