Forum Discussion
How to group items?
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
Anonymous
You may refer to the following post.
5 Replies
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
You may refer to the following post.
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
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
