Forum Discussion
create a line graph using a dynamic query
I need to create a line graph using a dynamic query that will receive as a parameter the value selected from a column of a table.
My data looks like this :
| ID | Name |
| 1 | New york |
| 2 | Boston |
| 3 | Chicago |
| 4 | Miami |
| 5 | Seatle |
then when selecting a city from the table I can bring the values that I need in the graph.
Note: the graph query is dynamic and receives as parameter the name of the city.
4 Replies
@ , if the table and line visual are interacting you can create visual like that
You can create a measure like one below and use in title to display city name
selectedvalue(Table[City])
https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
amitchandak the table and line visual are not interacting. Are independent data sources.
I have finally created a measure and with this I was able to solve, grateful!
HI Vilori1200 ，
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
Lucien
