- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Power Query
I am facing some issue building Decomposition tree visual in Power BI as my Data is not structured properly. So when i add teh data to visual it gives so many blanks. I filled down the data in the columns but that gives data mismatch for few rows. I really need some help. My data looks like this
And if i fill down the values it takes other initiative's epic and fills down to the new initiative and so on. im not quite understaning how to structure this.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @RachanaN - if you are planning to use decomposition tree visual structuring your data properly is crucial for before using visual effectively in Power BI. Based on your description, it seems like you have hierarchical data where higher-level categories (like Initiative) should be associated with multiple lower-level items (like Epics). Filling down values can sometimes cause mismatches if not handled correctly.
Ensure that no blanks are left in the higher-level columns after the fill down operation. If necessary, use additional transformations to replace blanks or handle special cases.Verify the logical structure of your hierarchy in Power BI and ensure it matches the hierarchical relationships in your data.
Hope it helps
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Proud to be a Super User! | |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @RachanaN - if you are planning to use decomposition tree visual structuring your data properly is crucial for before using visual effectively in Power BI. Based on your description, it seems like you have hierarchical data where higher-level categories (like Initiative) should be associated with multiple lower-level items (like Epics). Filling down values can sometimes cause mismatches if not handled correctly.
Ensure that no blanks are left in the higher-level columns after the fill down operation. If necessary, use additional transformations to replace blanks or handle special cases.Verify the logical structure of your hierarchy in Power BI and ensure it matches the hierarchical relationships in your data.
Hope it helps
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Proud to be a Super User! | |

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-10-2024 07:50 AM | |||
07-11-2024 09:37 AM | |||
07-08-2024 06:09 AM | |||
Anonymous
| 03-21-2024 08:15 AM | ||
10-02-2024 10:54 PM |
User | Count |
---|---|
141 | |
115 | |
84 | |
63 | |
48 |