I have county names as dublin1, dublin2, dublin3 how to make a single default name as dublin to those values in power bi?
I have tried to remove duplicates but it is not a correct solution.I have tried concatenate as well but it will be useful to merge columns.
You will need a Table similar to:
County | County Variation |
---|---|
Dublin | dublin1 |
Dublin | dublin2 |
Dublin | dublin3 |
You would then add a relationship on the second column to your data table(s). Lastly, you’d use the first column for your slicer.
Update your question with a sample table in markdown format together with what the result you want.