Forum Discussion
Row headers in a table
Hi,
I'm looking at adding row headers in my table so that you can expand and minimise the table e.g.:
On the below table you have your categories of conditioners and shampoo, you can then expand each to show the different options (leave in, rinse off etc...)
As a side note, is there a way to expand further? since you can expand Hair conditioner, say for example Conditioner - Leave in has options that you can expand on; is there also a way to add a +/- to that too?
On my table i have something similar;
For what i'm looking for:
i have my categories e.g. BEADS department, which should expand into Fixed asset management , inventory and ITOT when i press the +/- button.
How can i achieve this? essentially i want to remove the second column and have it placed in into the first under each department like the example shampoo/conditioner table.
Hope it's clear! thanks in advance.
Ahhh i see! apologies i was using a basic table instead of a matrix. thank you.
6 Replies
jonbox , Not very clear to me, You can add more rows and keep on expanding using the plus button.
There are two buttons on top of two parallel lines (next level) and reverse square Y (expand all)
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill
It's not very clear. But I'm guessing you should just add more rows to your matrix visual. You might have to reorder them.
You can then press the +/- to expand another level. Or press one of the icons from your visual header (expand, drill down, next level)
Hi jonbox .
Yes, you can add as many as Drill Paths to the matrix.
Just add those columns want in 'Rows' Fields.
Condition is that all the tables from which columns are taken should be related.
Regards,
Sanket
If this post helps, then mark it as 'Accept as Solution' so that it could help others.Hi Sanket,
Where can i find the rows field to put these columns in please?
