creating group from multiple cateogies

[Anonymous]

Hello,

I want to group values from different categories - for example I want to create a group for "cleaning products", but I have values in a Level 2 hierarchy under " house hold cleaning supplies", another Leve 2 heirachy called " residential cleaning services"  .  I see where you can right click on the chart on 2 categories and make to one...but I seems to not allow me to have more than one group  doing this way and also groups the others under "other".    Is there a best practice way to create grouping .?

[Anonymous]

Thanks - I figured out how to add groups in Power BI.  But this is also helpful if need to pull from different columns.

[v-jiascu-msft]

Hi @Anonymous,

Do you want to group values from different fields (columns)? If so, I'm afraid it's hard to do it directly. The workaround could be as follows.

1. Create a new table.

Group

Group A

Group B

2. Add a new column to the target tables and assign the group values to respective items.

Best Regards,

Dale