Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all,
I have calculated "average" latitude and longitude coordinates by converting them from decimal coordinates(lat/lon) -> to cartesian coorinates (x, y, z) -> and back to decimal coordinates (lat/lon). However, when attempting to plot them onto the map visualisation, I get this error message:
"Can't display this visual.
To display latitude and longitude pairs, set the aggregate for Latitude and Longitude to Don't summarize."
However, since they are measures, I do not have any option to set them to "Don't summarize". How can I plot these points?
@Greg_Deckler @koorosh
@Anonymous IDK, not sure if I ever tried using measures for map locations before. Perhaps you could try creating a calculated table? Seems like a bug to me. Measure, by definition, can only return a single, scalar value so seems like it should work as long as you have something in the Legend that uniquely identifies each point.
Hi @Greg_Deckler, sorry for late reply. The limitation of what i'm trying to do requires the map coordinates as calculated measures, which makes it tricky. I found a round-about way to do it without having it as measures (less accurate, but fits ~80% of the requirement) and it was good enough for me.
Thanks for your comment!
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
79 | |
61 | |
59 | |
58 |
User | Count |
---|---|
151 | |
113 | |
99 | |
80 | |
72 |