Forum Discussion

Zdenison's avatar
Zdenison
New Member
10 months ago
Solved

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...
  • danextian's avatar
    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]
    )