Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have PowerBI report with DirectQuery two tables in Azure SQL database.
Tables look like the following and there's a one-to-many relationship between Table A and Table B on column, TraceID.
What I'm trying to do is create a line chart using DateTime as the Axis, HostName as the Legend, and RTT and the Value. This creates a nice line chart over time showing me what the network latency from the host to target is. Table B contains the traceroute details of a record in Table A, related by TraceID.
What I'm trying to do is when I select any given point in time on the line chart, I want it to query the Table B for all records that match that specific TraceID and display those records in a Table chart.
Any idea how I can accomplish this? Thanks!
Table A
Table B
Hi @jinkang23,
The workaround could be using a Line and stacked column chart instead. Then you can click the column to filter. You can make the color of the columns lighter.
Also you can vote on this idea: https://ideas.powerbi.com. Maybe we can filter other tables in the line chart in the future.
Best Regards!
Dale
Hi @jinkang23,
Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.
Best Regards!
Dale
I have PowerBI report with DirectQuery two tables in Azure SQL database.
Tables look like the following and there's a one-to-many relationship between Table A and Table B on column, TraceID.
What I'm trying to do is create a line chart using DateTime as the Axis, HostName as the Legend, and RTT and the Value. This creates a nice line chart over time showing me what the network latency from the host to target is. Table B contains the traceroute details of a record in Table A, related by TraceID.
What I'm trying to do is when I select any given point in time on the line chart, I want it to query the Table B for all records that match that specific TraceID and display those records in a Table chart.
Any idea how I can accomplish this? Thanks!
Table A
Table B
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |