PBI matrix, Expand last month not previous.

[Bob_Sacaman0913]

Hi!

I'm a bit new to PBI, coming from the pivot table reality. 

I'm using a matrix to look att logistic's stuff. I'd like to se the most resent data expanded but not the previous. 

Like in the first piture below (from a pivot table). I want this month to be expanded to weeks, but not the previous months. And likewise I want this year to be expanded into months but not the previous year. 

I'cant figure out how to achive this in the PBI matris, all I manage to do is to either expand all or non of the mentiond column headers. Like image two below. 

I'm thankfull for any help I can get!

[v-jayw-msft]

Hi @Bob_Sacaman0913 ,

You could try selecting the downward arrow and clicking the hierarchy you want to expand.

Then the visual will only expand that hierarchy you click instead of all visual.

For more information about drill mode in Power BI, please take a look at this document.

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill#learn-how-to-drill-down-and-up 

Best Regards,

Jay

[Bob_Sacaman0913]

Hi and thanks for your reply!

Sure I can drill down but I dont want to drill down all the months. I want to drill down as shown in this image (se attached image). 

I've stubbled accross some similar posts and seemes that this isn't possible in PBI. But there is sure to be some workaround.