Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi...I'm working on a report that reflects sales. I have regions that combine more than one country, for example Argentina and Uruguay. How can I represent that on a map when the region is called "Argentina & Uruguay"? I'd like to select a value and see the map highlighting those 2 countries.
Any idea would be appreciatted it
Thanks,
Ezequiel
Solved! Go to Solution.
@ezequiel You can resolve this couple ways...
Either add a Region Column to your Source
OR
create a table with just these 2 - Country Column and Region Column and relate it to your Sales table by Country
@ezequiel You can resolve this couple ways...
Either add a Region Column to your Source
OR
create a table with just these 2 - Country Column and Region Column and relate it to your Sales table by Country
Thanks all. It worked!
Haven't tried this, but potentially you could create a table with your "sales areas" such as:
Sales Area,Country
Argentina & Uruguay,Argentina
Argentina & Uruguay,Uruguay
Relate that to your fact table on "Country" column. Then put the "sales area" table's "Sales Area" column in a slicer and you should be able to use that to filter your map visualization.
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |