Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
After a bit of help!
I'm working with summary data extracted from a system we are using. The data is summarised at different levels in the organisation
Table_Scores
Org Level | Org Name | Average Score |
1 | Company 1 | 6.5 |
2 | Division XYZ | 8.6 |
3 | Business Unit 12 | 7.7 |
3 | Business Unit 23 | 8.9 |
etc. |
and I have an organisation table similar to the below
Table_Org
Org Level 3 | Org Level 2 | Org Level 1 |
Business Unit 12 | Division XYZ | Company 1 |
Business Unit 23 | Division XYZ | Company 1 |
Business Unit 34 | Division ABC | Company 1 |
etc. |
Note I only have the summarised scores for each level so can't calculate it bottom up which I'd usually do.
I'm trying to create a dashboard where the user selects the org level 3 of interest using a slicer and then show three cards at the top showing the scores for the level plus it's parent levels
Org Level 3 : Business Unit 12 : Score 7.7 | Org Level 2 : Division XYZ : Score 8.6 | Org Level 1 : Company 1 : Score 6.5 |
At the risk of pushing my luck it would be good to have a bar chart showing the three values.
I guess what might faciliate this is a summary table that updates according to the slice and stores the values?
I've tried a few approaches and got close but nothing seemed to work 😞
Any help/ideas really appreciated!
Richard
Solved! Go to Solution.
Hi @worthywow1988, you can create something similar:
Did the solution dufoq3 offered help you solve the problem, if it helps, you can consider to mark it as a solution so that more user can refet to.
Best Regards!
Yolo Zhu
Hi @dufoq3
Really appreciate you taking the time to help and creating the example - many thanks. I'll give this approach a go and report back!
Thanks again!
Check out the July 2025 Power BI update to learn about new features.