Forum Discussion

juliamanda's avatar
juliamanda
Regular Visitor
3 years ago

Two questions about Matrix visual

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

Need Help

1 Reply

  • juliamanda's avatar
    juliamanda
    Regular Visitor
    3 years ago

    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