Forum Discussion
Zdenison
10 months agoNew Member
Financial PL View with Custom Layout Help
I am working on building a Financial PL in Power BI and I have Accounts and then GL Accounts that roll up to them, I have created a custom table that formats the PL to look like a standard PL and all...
- 10 months ago
Hi Zdenison
It isn't currenlty supported to selective disable the expand icons. You can however, write a condition so when a certain category is expanded, it won't show the lower level hierarchy. Try this sample measure
// Hide the measure value when drilling down to the account code level // for specific summary categories to avoid showing duplicate totals IF ( // Check if we're at the detail level (account code and name is visible) ISINSCOPE ( 'table'[account code and name] ) // AND the current row is a summary/total category && 'table'[account category] IN { "Total Revenue", "Total Income", "Etc" }, // If both conditions are true, return blank (hide the value) BLANK (), // Otherwise, show the normal P&L measure value [pnl measure] )
v-hashadapu
10 months agoCommunity Support
Hi Zdenison , Hope you're doing fine. Can you confirm if the problem is solved or still persists? Sharing your details will help others in the community.