Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Khalidc
Frequent Visitor

Dynamic hierarchy based on amount

Hi 

 

I have the following challenge. I have designed a balance sheet for financial purposes. However, some items in the hierarchy should be presented as a receivable or payable based on whether it is a positive or a negative value.

 

For example, Taxes could be in 1 period a receivable (positive value) while in another period a payable (negative value). So based on the amount the presentation should be defined. Below a print screen how it looks like.

 

The solution I have in mind is to duplicate the lowest level in the hierarchy (general ledger), and design the measure to be blank if the condition is not met. However, this will result in a loss of the 1 to many relationship and making the model less robust. And adding some manual labour to it.

 

Do you see any easier solution to design a dynamic hierarchy? 

 

Khalidc_0-1667571158348.png

 

1 REPLY 1
daXtreme
Solution Sage
Solution Sage

I have serious doubts if it's possible to give you any good answer without having the data and model lying in front of us...

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.