Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Sync Matrix Granularity with graphs


On my PowerBI report I am using  Matrix with measure related to product categories and when expended by clicking on the + product subcategories. Around I have other visuals such as pie chart and scatter plot. I would like my visuals to be shown at the product category level (legend = product category) the matrix is being expended, meaning the user has selected a product subcategory, when I would like my graphs to now be shown on the subcategories level. 


I have tried using parameters but it is not exactly the solution as I am looking for something interactive with the matrix. Any idea on how to do this?


Thank you!

Super User
Super User

@charlottesmn , I doubt that us possible, as of now we can not change axis conditionally. Field parameter is best option if that can work

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors