Forum Discussion

zurab4000's avatar
zurab4000
Frequent Visitor
3 years ago

Dynamically Change Data Source Using Parameter and Slicer

Hi,    I have Data Source: https://example.com/v1/{city}/api=1.0 . I created parameter (list_param) "List of Value" with City names. I changed the source : Source = Json.Document(Web.Contents(Tex...
Need Help
Adamboer's avatar
Adamboer
Responsive Resident
3 years ago

To achieve this, you can create a slicer with the values from the "list_param" parameter. Follow these steps:

  1. Go to the "Visualizations" pane in Power BI Desktop.
  2. Click on the "Slicer" visual to add it to your report page.
  3. Select the "list_param" parameter from the "Fields" pane.
  4. The slicer will automatically be populated with the values of the parameter.
  5. Select the values from the slicer to filter the data in the table visual.

This way, you can use the slicer to dynamically filter the data based on the selected city name.