Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Anonymous
Not applicable

Plotting Latitude and Longitude with What-if Values

Hi all,

I'm trying to use What-If parameters to dynamically generate latitude and longitude on a map.   I also want to be able to use Single Value Slicers (What-If Parameters).

However, when I plot the selected value for each I get the following error.

wallace13_0-1660876539119.png

 

Since these are measures ( SELECTEDVALUE(...) )there is no way to adjust any aggregations.

Does anyone know of anyway I can achieve this?

I've tried a number of approaches and found several dead ends.
- Tried loading the SELECTEDVALUE() measures into a table, however the values don't update if in a true table format and not stored as measures.
- Tried generating my own array of Lat. and Long. from a custom table, and using slicers to pick.  However then I can't use the single value slicer since it isn't a What-IF.  (NOTE:  I cannot access Tabular Editor, locked down IT environment, so the back end customization type fixes to trick the Wizard are not potential solutions for users like me).

Thanks!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

I ultimately had to just get Tabular Editor to change the filtering to the way I wanted.

Here are the instructions I followed.

https://www.youtube.com/watch?v=Tyv0lDUK2rw

If you are running Tabular Editor 2, you will need to also go into the Tabular editor settings menu to show the extended properties.

File, Preferences, Features > Allow Unsupported Power BI Features

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

Hi lbendlin,
I want to be able to do two things:

- plot a user defined coordinate point on the map at the set latitude and longitude

- use the user defined latitude and longtitude for other measures (such as for calculating the distance to other points - I already have the measures for this)

Looks like we are already failing at the first hurdle.  The map visuals do not accept measures as data points for latitude and longitude.

 

lbendlin_0-1661291112102.png

 

Anonymous
Not applicable

Yes, I was not trying to put the measures in directly, since those won't work.  I was trying to use filters on What-if parameters/generated tables to filter a range of values.  What if parameter fields (the generated values) don't work directly either since it can't determine the relationship between the values even if one is selected:

wallace13_0-1661304830543.png


If you generate table of all the latitidues and longitude you can filter those and get a result, the problem is you can't use the single value slicer, or a search slicer, you can only do dropdown, list, or between/greater than/less than slicer,  None of these slicers are intuitive for picking a point on a map. 

wallace13_1-1661304952858.png

 

It might be possible to create a measure filter for a plus/minus x range around a location. Or if you want to be fancy, a radius. Would that help?

Anonymous
Not applicable

I ultimately had to just get Tabular Editor to change the filtering to the way I wanted.

Here are the instructions I followed.

https://www.youtube.com/watch?v=Tyv0lDUK2rw

If you are running Tabular Editor 2, you will need to also go into the Tabular editor settings menu to show the extended properties.

File, Preferences, Features > Allow Unsupported Power BI Features

lbendlin
Super User
Super User

Please provide a more detailed explanation of what you are aiming to achieve. What would you do with the result of these what-if slicers?

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.