Hello Everyone,
I have a web app where I am using PowerBI Premium Embeded and have been using the PowerBI JavaScript API to show my reports in my app and to add filters to said report and all has worked great until I hit a roadblock. Normally I just use the Basic and Advanced filters and have a list of values that go with one column in each filter.
This only became an issue when I was asked to add the abiliity to filter on multiple Sets of Latitue and Longitude. SO of course each set has 2 values that need to pull from different columns (lat and long) and have the logic operator AND between them.. However, since I need to pass multiple sets I will need to use the Logic = OR between the sets of Lat and Long.
Esentially I need to be able to pass values like below......
Lat : 47.2042681 AND Long: -121.9915003
OR
Lat : 47.2004603 AND Long: -122.2196947
OR
Lat : 47.1982537 AND Long: --122.2949605
Is there any way to add these to a report through the PowerBI JavaScript API? I would love any kind of feedback asap as I need to get this feature out. Thanks.
