Collapse month columns on matrix for previous years and expand months on current year column

[ejsoccer5]

I'm trying to show a matrix of paid date (rows), and service date (columns). I can collapse and expand on the rows like usual, but I'm trying to have the columns collapse when it's a previous year and expand when it's the current year. 

The columns would be year > month to expand to. Looking to do the below visual (pivot in Excel) in PowerBI 

[Anonymous]

Hi @ejsoccer5 

Can you tell me if your problem is solved? If yes, please accept it as solution.

Regards,

Nono Chen

[Anonymous]

Hi @ejsoccer5 

@amitchandak Good share!

Based on the image you sent, it looks like you want to create a matrix with collapsible columns based on the year and month of the service date. However, this functionality is not available in the native PowerBI Matrix visual as you can only freely expand or collapse rows, not columns.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@ejsoccer5 , I doubt with standard matrix. You can check custom visual
https://appsource.microsoft.com/en-us/marketplace/apps?search=matrix&page=1