Sql data interactions

Thanks for the reply matt. Okay just to be sure let me ask with me sql code.THis was my initial idea.

GRAPH A
------------------------------------------------
SELECT TOP (10)
[Project1].[C3] AS [C1],
[Project1].[ParentTaxonomyName] AS [ParentTaxonomyName],
[Project1].[C2] AS [C2]
FROM ( SELECT
[GroupBy1].[A1] AS [C1],
[GroupBy1].[A2] AS [C2],
[GroupBy1].[K1] AS [ParentTaxonomyName],
1 AS [C3]
FROM ( SELECT
[Extent1].[ParentTaxonomyName] AS [K1],
COUNT(1) AS [A1],
COUNT(1) AS [A2]
FROM [dbo].[VariableOrderTaxonomies] AS [Extent1]
WHERE [Extent1].[IsBestFit] = 1
GROUP BY [Extent1].[ParentTaxonomyName]
) AS [GroupBy1]
) AS [Project1]
ORDER BY [Project1].[C1] DESC

Graph B changes when parent taxonomy name is clicked
---------------------------------------------------
SELECT TOP (5)
[Project1].[C3] AS [C1],
[Project1].[SubTaxonomyName] AS [SubTaxonomyName],
[Project1].[C2] AS [C2]
FROM ( SELECT
[GroupBy1].[A1] AS [C1],
[GroupBy1].[A2] AS [C2],
[GroupBy1].[K1] AS [SubTaxonomyName],
1 AS [C3]
FROM ( SELECT
[Extent1].[SubTaxonomyName] AS [K1],
COUNT(1) AS [A1],
COUNT(1) AS [A2]
FROM [dbo].[VariableOrderTaxonomies] AS [Extent1]
WHERE ([Extent1].[IsBestFit] = 1) AND ([Extent1].[ParentTaxonomyName] = '<ParentTaxnonomyName>')

/* The angular brackets is the unknown that i want to show the relavent parent taxonomyName is clicked on A*/

GROUP BY [Extent1].[SubTaxonomyName]
) AS [GroupBy1]
) AS [Project1]
ORDER BY [Project1].[C1] DESC

So if i want to make it interactive, i would need to fetch both results to the same table correct then Power BI will allow interactions correct?