Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello everyone,
So im having this problem:
I have a column with the status of different projects: i.e In progress, Completed, etc:
But, I want to replace some status text for other text, for example I want to replace "CERRADO" (spanish word) to "In progress", so what im doing is using the replace values tool in the edit query, and changin one text to the other. The actual problem is that when I do that, I end up having two exact text but power Bi is counting as if they were different:
So if I try to make a chart based on that data, im going to have duplicate information for the different categories of the status of the project. For example im having one bar of "Completed" with a number of 10 projects and then another bar in the same chart with the same label of "Completed" with 20 projects. What I want its to only have 1 bar with a number of 30 projects.
I already try to check if maybe I was putting a blank space when doing the replace values but everything is ok.
I hope you can help me. Thankyou very much!
Before you do the Remove Duplicates step, try two transformations:
If that still doesn't work, in the PQ window, click on each value you think should be the same and look in the window below. You can even select that data and put it in something like NotePad++ and try and figure out what else is in there.
For example:
In the table, these look the same, but when I click on each and highlight below, I can see there are trailing spaces on the 2nd entry, and PQ will not remove that as a duplicate until you TRIM it.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingStarting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
87 | |
67 | |
49 |
User | Count |
---|---|
135 | |
113 | |
100 | |
68 | |
67 |