How to group items?

[Anonymous]

I am trying to generate a report similar to the example below but I cannot get the report to group my Product.  From what I can find the "Group" feature in PBI is for grouping within a given field, which seems all but useless. 
I get two results:
1. The Product Areas are ignored. 

2. Project Types are ignored. 

How do I display both? 

The data hierarchy is as follows:

Products contain Projects 

Each project falls into a Project Type (example shows A-F)

Each Project has a Status

[Greg_Deckler]

I believe you should be able to do an add-hoc hierarchy in your x-axis with Products and then Projects. Then use Status as your Legend. Use a Stacked column chart. You will want to use the forked arrow to drill through from Products to Projects.

Grouping has its uses.

[Anonymous]

Thanks, but that doesn't work. I get the same results as if I didn't have a hierarchy. 

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/concatenate-Labels-does-not-work-properly/m-p/415010#M19113...

[msalahkar]

Hello @Daviator

If I'm getting you right, you need a 3-axis chart. Here's a discussion about it that might help.

https://community.powerbi.com/t5/Desktop/Line-chart-with-3-axis/td-p/150909

[msalahkar]

Hi @Anonymous 

If i am getting you correctly, you need a chart with 3 axis. Here is a discussion regarding it which might help you.

https://community.powerbi.com/t5/Desktop/Line-chart-with-3-axis/td-p/150909