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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
wallace13
Advocate II
Advocate II

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

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
wallace13
Advocate II
Advocate II

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

 

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?

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors