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.
Hello,
I´ve been trying to classify a certain latitude/longitude(point) within Power Bi according to an specific area which is not exactly a Shape Maps / Choropletic Standard (Country, state, etc).
The area its an specific one for a special need, I tried with ArcGis "Multiple Select" and its kinda what I need, but it only filters them, and I need to classify them according to that area, something quite like a "Conditional Column" According to that specific area.
Thank you very much for your help!!!!
Miguel
Solved! Go to Solution.
Hi,
According to your description, i create a simple sample to test:
Then i define a policy and create a calculated column to show its area:
Area =
SWITCH (
TRUE,
'Table'[Latitude] <= 53.00
&& 'Table'[Latitude] > 52.00
&& 'Table'[Longtitude] <= -99.50
&& 'Table'[Longtitude] > -99.54, "Area1",
'Table'[Latitude] <= 54.00
&& 'Table'[Latitude] > 53.00
&& 'Table'[Longtitude] <= -99.40
&& 'Table'[Longtitude] > -99.50, "Area2",
'Table'[Latitude] <= 53.00
&& 'Table'[Latitude] > 52.98
&& 'Table'[Longtitude] <= -99.30
&& 'Table'[Longtitude] > -99.39, "Area3",
'Table'[Latitude] <= 53.30
&& 'Table'[Latitude] > 53.00
&& 'Table'[Longtitude] <= -99.10
&& 'Table'[Longtitude] > -99.30, "Area4"
)
And it shows:
Add this [Area] column to map visual, the result shows:
Hope this helps.
Best Regards,
Giotto Zhi
Hi,
According to your description, i create a simple sample to test:
Then i define a policy and create a calculated column to show its area:
Area =
SWITCH (
TRUE,
'Table'[Latitude] <= 53.00
&& 'Table'[Latitude] > 52.00
&& 'Table'[Longtitude] <= -99.50
&& 'Table'[Longtitude] > -99.54, "Area1",
'Table'[Latitude] <= 54.00
&& 'Table'[Latitude] > 53.00
&& 'Table'[Longtitude] <= -99.40
&& 'Table'[Longtitude] > -99.50, "Area2",
'Table'[Latitude] <= 53.00
&& 'Table'[Latitude] > 52.98
&& 'Table'[Longtitude] <= -99.30
&& 'Table'[Longtitude] > -99.39, "Area3",
'Table'[Latitude] <= 53.30
&& 'Table'[Latitude] > 53.00
&& 'Table'[Longtitude] <= -99.10
&& 'Table'[Longtitude] > -99.30, "Area4"
)
And it shows:
Add this [Area] column to map visual, the result shows:
Hope this helps.
Best Regards,
Giotto Zhi
Thank you very much for your help Giotto, I solved it !
Miguel
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 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |