Groups and Drill through

[Anonymous]

Please Help!!

I've created groups companies which have a parent company i.e.

PARENT

Big Company (GroupName)

         A Company

         B Company

         C Company

Big Company2 (GroupName)

        D Company

        E Company

I then created a drill through page

Problem --------

When I drill though Big Company or Big Company2

The drill shows the first Item in the group list and not Big Company or Big Company2 GROUPED

is there a solution , or am i missing something?

Alan

[v-xuding-msft]

Hi @Anonymous ,

After testing, if we add the group into the detail page rather than items, it will show groups. Please see my pic and attached file. 

If I understand incorrectly, please show us some screenshots.

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. Kudos are nice too.

[Anonymous]

I Understand what you've done ....but it seems to defeat the whole object of grouping if ...as i understand it you created a table (column) to group in the first place. 

Tell me I got this wrong I would have to either create a new table or ...find and replace the original table(column)?

[Anonymous · Accepted solution]

If your main table has not both attributes (MainCompany + Company) like:

MAIN COMPANY	COMPANY	QTY	VALUE
1	A	5	50
1	B	3	9
2	D	8	48
1	C	1	4
2	E	9	36
1	A	1	10
2	D	4	32

This way Power BI can make the grouping automatically, if it's not the case there's no way for Power BI to realise the association.

So either you tell with a table what Companies belong to each Main Company or you group as suggested above.

Let me know if it helped, if it worked please mark as solutions, if it didn't we keep trying.

BR,

DR

[Anonymous]

I have something similar, but slightly different. I want to select a product and then have to option to drilldown either to 1) product details page or 2) product group details page (showing the details of all products in the product group of the selected product).

For 1 I have no problems, but for 2 I cannot drilldown or I can drilldown but then a filter is applied to the product, so showing only details of that product and not of all products in the product group. I can obviously include product group to the main table, and drilldown on product group, but my users want to select a product and not a product group.

Any suggestions how I can set this up?

[Anonymous]

You can have only one table with two columns like this:

Big Companies	Companies
Big Company 1	A
Big Company 1	B
Big Company 1	C
Big Company 2	D
Big Company 2	E

And then connect the second column to your fact table or your company dimension table.

Let me know if it helped.

BR,

DR