Matrix visual + multiple column layers

[zahlenschubser]

Hi Forum, I would appreciate a little help here.

What I am trying to get is a matrix visual with multiple layers of date-related columns:

	May					June
	1	2	3	4	…	1	2	3	4	…
a
b
c
d

But if I add both to the visual it shows either just the days or just the month, depending on what field I drag into the first position on the visual, not both.

[Anonymous · Accepted solution]

Hello @zahlenschubser,

You can achieve this by using drill down one level option at the top right corner of the matrix as show in below image. 

Thanks.

[zahlenschubser]

As a variation of this, how would you solve showing the quarter only for "finished" quarters and the months for the current quarter?

So like
Q1 / April / May / June

[zahlenschubser]

Thank you very much, that works! 😃