Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
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.
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!
Solved! Go to 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
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.
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:
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.
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
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?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
88 | |
85 | |
82 | |
65 | |
49 |
User | Count |
---|---|
138 | |
110 | |
104 | |
66 | |
64 |