Forum Discussion
pivot table drill down
I want to drill down from year to month in columns of matrix same way i am doing for category to subcategory as shown below, how can we achieve it in Power BI
Hello powerbiexpert22 ,
if you mean with the "+" button, you can't do it right now. That feature is not available. Take a look on the forum for other topics on this, like this one https://community.fabric.microsoft.com/t5/Desktop/expand-collapse-for-column-matrix/m-p/1079870
But you can drill down with the header icons, just switch from "Drill on: rows" to "Drill on columns"
Hope I made my point 😉