Forum Discussion

phchu1226's avatar
phchu1226
Icon for Helper IV rankHelper 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'...
Need Help
selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost 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
Icon for Helper IV rankHelper 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.