Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm new to PBI, so pls excude trivial question.
I want to merge two continents and generate a new region.
E.g. Merging North America And South America ( 2 continents) and replace them by "The Americans" (1 region).
Note - This new value has to be used as a filter.
Solved! Go to Solution.
Hi @ShashankV16,
For your requirement, you can try to open the query editor and use replace value function to replace the specific values.
Steps:
1. Click "Edit Queries".
2. Choose column which you want to replace.
3. Right Click and select the replace value option.
Regards,
Xiaoxin Sheng
Hi @ShashankV16,
For your requirement, you can try to open the query editor and use replace value function to replace the specific values.
Steps:
1. Click "Edit Queries".
2. Choose column which you want to replace.
3. Right Click and select the replace value option.
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |