Forum Discussion

phchu1226's avatar
phchu1226
Helper IV
5 years ago
Solved

PowerBI column control while drill up/down

Hello,

 

Do anyone know whether PowerBI have this kind of feature?

The matrix will show more columns while drill-down, just like the images below.

In the first dimension, PAP, it contains 'sales' and 'order' column only.

While drilling down, it show two more columns, which are 'Count of Size2' and ''Count of Size3'.

Or any other way/suggestion to achieve this?

Thank you so much in advance!😃

 

 

 

Need Help

9 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey phchu1226 ,

     

    yes that is possible. You can do drill down on rows and also on columns.

    For columns just do it like for rows, add a hierarchy and then you will have the option to drill down there as well. Take a look here:

     

    Also check out the whole article:

    Create a matrix visual in Power BI - Power BI | Microsoft Docs

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
    • phchu1226's avatar
      phchu1226
      Helper IV
      5 years ago

      selimovd 

      Hello,

       

      I know that there also is the drill down in columns.

      My own thought is that I hope I can drill down in rows together with the column at the same time.

      Is there any feature of PowerBI can achieve this?

       

       

      For example, when I drill down the first dimension 'PAP', it will also drill down in column, that is, two more columns appear 'Count of Size1' and 'Count of Size2' after drill down to '1LDGCNF-250-25.5-36.75'.

       

      In my case, PAP do not have any data about size2 and size3 as PAP is just a group, display size2 and size3 in this dimension is meaningless. The data of size2 and size3 need to be found in the second dimension (i.e. '1LDGCNF-250-25.5-36.75', so I hope that I can just show the data of size in the second dimension instead of the first dimension.

       

       

       

       

    • phchu1226's avatar
      phchu1226
      Helper IV
      5 years ago

      selimovd 

      Hi, maybe little confused if I use 'Count of Size 1' and 'Count of Size 2' as the example.

       

      what I want to do:

      1: no need size1 and size2 in this dimension, and dont display size1 and size2 column, as it is meaningless to show the sum or average of size in this level

      that is, just need sales in this dimension.

       

      2. when drilled down, show the size1 and size2 for each item.

       

      Is it possible to do this?🤔