Custom Matrix Drill down

[Anonymous]

Hi All,

I have got a requirement in power bi in which I need to drill down a few columns while other measures should remain intact. Please look at the sample and suggest if it is possible.

sample table

Manager           Employee              Employee_level2                Ratings

A                        G                           K                                         1

B                         H                          L                                           2       

C                        I                             M                                        3

A                         G                         N                                          4

A                        H                           O                                         5

B                        I                            P                                           6

B                         J                            Q                                          7

Please forgive the indentation. Now the requirement is that the data should be visible as 

Manager          Rating

A                     1              Measure1

                                       Measure2

B                      2               Measure1

                                        Measure 2

.

.

.

F                      6            Measure1

                                      Measure2

And the data should drill down from Manager -> Employee -> Employee_leve2 but the ratings should be visible every time along with the measure (can be anything like cost, selling price etc)

[v-xuding-msft]

Hi @Anonymous ,

You could use the option of expending to the next level in matrix to implement. If you just want one fixed column and then to drill down others, it is not supported now.

Best Regards,

Xue Ding 

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