Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi
I have created a tree map for project count data which are grouped by Division wise and then subgroups by departments. I am getting count label by department i.e. subgroup wise. I want the count for main group as well. I have looked around but couldn't find any option. Please let me know, if there is a way where we can put count to the main group as well.
PFA screenshot for the same. I want the count for each division as well, division 1 count i.e. (sum of all dept in division 1) and similarly for all the divisions.Need count for each division as well. I am getting count dept wise only.
Thanks in advance.
Regards,
Sahil
Hi @sahilhira162,
Please share a dummy sample.
Best Regards,
Dale
Is it not possible to get the count both by group wise and subgroup wise. I have attached report and exported data as well.
Kindly suggest the same.
Regards,
Sahil
Can you share some sample/example data so that we can see how it is currently organized?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
56 | |
38 | |
35 |
User | Count |
---|---|
85 | |
66 | |
59 | |
46 | |
45 |