Forum Discussion
Matrix visual + multiple column layers
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.
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.
3 Replies
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.
Thank you very much, that works! 😃
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
