Reply
RachanaN
New Member
Partially syndicated - Outbound

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 

RachanaN_0-1720768129413.png

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.

1 ACCEPTED SOLUTION
rajendraongole1
Super User
Super User

Syndicated - Outbound

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!!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

1 REPLY 1
rajendraongole1
Super User
Super User

Syndicated - Outbound

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!!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)