Two questions about Matrix visual

[juliamanda]

Hi,

I am trying to build a matrix like in the picture below. The greyed column area would show latest, second latest and third latest Year, Quarter and Month, depending on the level matrix is drilled on. Drilling would not affect on the unit categories (U1, U2, U3).

Right now the field panel looks like this and it is not giving the wanted solution since units are showing separately from time periods.

So, my questions are:

1. Is there any way to "nest" the unit column under time columns so that it would visible no matter what level the visual is drilled on?

2. How to show only latest three time periods?

Thanks in advance! 🙂

Julia

[juliamanda]

Until now I have discovered.

Filterin TOP3 works but it can be used for only one field inside same matrix.

Visual level measure works with other visuals but not with matrix...

Measure = IF(MAX('Table'[Date])=MAXX(ALL('Table'),[Date]),1)

Julia