Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, Being a Newbie requesting suitable solution and a suitable viz for presenting hierarchial data analysis.
Source data set sample as below.
Created the structure as below in POWER BI
Now request help to arrive at an analysis format like below which shall help to find the variance at all Nodes which are Parent/Grand Parent/Great grand parent (except only child nodes) like a drill down to each child level where the aggregation happens.
Prepared the data set with calculated columns as per enclosed PBIX file and struck there to proceed further.
https://drive.google.com/file/d/11an1tuJt5ColpEHwAe7AR4yjVi180PB7/view?usp=share_link
Deeply appreciate your timely help.Thank you.
Hi @InsHunter ,
I'm a little confused about your needs, Could you please explain them further?
Thanks for your efforts & time in advance.
Best regards,
Community Support Team_Binbin Yu
Thanks for your response.
Objective of this excercise is to reconcile the data under 'Values' column. The data capturing points are child nodes which can be either only a child or may be a parent (for the next level) as well as child. The realtime data is captured at all nodes and parent node data need to be equal to aggregated child node data. In Practical situation this may not match and thro reconcilation to find the loss intensityand quantify the same against all Parent nodes.Hope i could make some clarity by the above statements.
Best regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |