Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have created a map with production volumes but I don't see where to set the ranges for my thematics. Currently it is giving me a different colored dot for each location. Can someone tell me where you set the ranges?
Solved! Go to Solution.
Hi @Ajwestergren,
For your requirement, please create a calculated column using the similar formula like the following
NewValue=IF(Table[Amount]<=100,1,IF(Table[Amount]<=500,2,3))
Then add the 'NewValue' as size level instead of your resource table, then size of farms with <=100 production amount are smallest, then size of farms with 100-500 production amount are bigger, size of farms with >=500 production amount are biggest.
Best Regards,
Angelia
Hi @Ajwestergren,
Which map do you use? Could you please share a screenshot for further analysis? I create a general map as follows. The year sales(highlighted in yellow background) is bigger, the size of the dot is bigger. What's your meaning of the ranges? Please share more details, so that we can post solution which is close to your requirement.
Best Regards,
Angelia
I have dairy farms that produce milk and I want to show the amount produced by ranges 100-500 lbs, 500-100 lbs represented by different sized points. I have gotten it to the point for the inserted resultsbut can it get to this type of result?
I am using the map feature not the ArcGIS
Hi @Ajwestergren,
For your requirement, please create a calculated column using the similar formula like the following
NewValue=IF(Table[Amount]<=100,1,IF(Table[Amount]<=500,2,3))
Then add the 'NewValue' as size level instead of your resource table, then size of farms with <=100 production amount are smallest, then size of farms with 100-500 production amount are bigger, size of farms with >=500 production amount are biggest.
Best Regards,
Angelia
Yes this worked perfectly. Do you know why when you filter on data related to a map like this the points move from their original location? For instance I will have a point in eastern Wisconsin that when filtered moves out into Lake Michigan. Considering these are plotted by longitude and latitude it seems odd that it does that
User | Count |
---|---|
96 | |
86 | |
78 | |
72 | |
67 |
User | Count |
---|---|
110 | |
103 | |
84 | |
65 | |
62 |