Solved: Table or matrix with drill down function

GDSHAW · ‎08-10-2016

Is there any visual in Power BI similar to table or matrix in which drill down function is available ? As we can't select any value in Table or matrix visual. I want similar presentation as table and matrix are having but i need drill down function too. Please suggest.

MattAllington · ‎08-10-2016

I normally use (and recommend) a bar chart with a hierarchy or nested levels. Right click e bar, drill down. If you need to see the numbers at any time, either swap to a matrix or turn on "see data"

* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

View solution in original post

MattAllington · ‎08-10-2016

I normally use (and recommend) a bar chart with a hierarchy or nested levels. Right click e bar, drill down. If you need to see the numbers at any time, either swap to a matrix or turn on "see data"

* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.