Forum Discussion

mafioso's avatar
mafioso
Helper II
8 years ago
Solved

Power BI drill through multiple parameters

Hi,

 

I have a matrix with cost centers (rows) and months (cols). I want to drill through by both arguments. It's currently just working for rows. Do you have any ideas how to fix that?

Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi mafioso,

     

    We need to make sure there exists hierarchy we can drill through. Then we can choose which one to drill. Please refer to the snapshot below.

    Power_BI_drill_through_multiple_parameters

     

     

    Best Regards,

    Dale

1 Reply

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi mafioso,

     

    We need to make sure there exists hierarchy we can drill through. Then we can choose which one to drill. Please refer to the snapshot below.

    Power_BI_drill_through_multiple_parameters

     

     

    Best Regards,

    Dale