Forum Discussion

solarnstorage's avatar
solarnstorage
Regular Visitor
8 years ago
Solved

Parameters setting other parameters

Hi,   I want to show specific weather data for one city at a time, among a list of different cities, as requested by the user. The data grab works through a URL that has a numerical code for a spec...
  • HotChilli's avatar
    HotChilli
    8 years ago

    You must be quite close because haven't you already edited your M code to append the number (which is in the parameter) to the URL?

     

    You then have to add a line before 'Source = ..... ' in the advanced editor of your query which creates a new variable, something like           CityNo = if CityParameter = "Webster" then "4954677" else if CityParameter = "Mayer" then "5036896"

     

    You then use CityNo in the URL which gets assigned in the 'Source =' line.

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi solarnstorage,

Could you please offer me some sample data and post your desired result if possible?

 

Regards,

Daniel He

solarnstorage's avatar
solarnstorage
Regular Visitor
8 years ago

I think HotChilli has the right idea, I'm trying to figure out how to do that.

 

My table looks like this:

 

 

The parameter I want the user to be able to filter the data with is the city name: Webster or Mayer. But the value I have to pass to as a parameter to the URL is the numerical code (4954677 for Webster). I don't know how to connect that together.

 

Thanks!

 

 

  • HotChilli's avatar
    HotChilli
    Icon for Community Champion rankCommunity Champion
    8 years ago

    You must be quite close because haven't you already edited your M code to append the number (which is in the parameter) to the URL?

     

    You then have to add a line before 'Source = ..... ' in the advanced editor of your query which creates a new variable, something like           CityNo = if CityParameter = "Webster" then "4954677" else if CityParameter = "Mayer" then "5036896"

     

    You then use CityNo in the URL which gets assigned in the 'Source =' line.