Dynamic headers for a balance sheet

Hi Mpmp1​ 

Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.

Mpmp1​ 

I believe "fabric model" you mean a semantic model in Direct lake storage mode. If so then create calculated columns or custom tables in direct lake storage mode. As long as you are using direct lake on one lake, please refer the below blog

Direct Lake Calculated Columns (Preview) | Microsoft Fabric Community

If you are using direct lake on sql, then for custom column or custom table you can directly create them with your warehouse or lakehouse and use it. 

If none of the options solves your requirement and you still want to use a measure as column header then its not possible in power bi native table or matrix visual. However I created a custom visual using calude code called "Smart Table" and wrote a blog about its features, you can refer to it.

https://www.techietips.co.in/articles/powerbi-smart-table

It’s a semantic model on fabric so I can’t add a column. Only measure 

Mpmp1​ 

Yes this possible,  assume your legal-entity dimension has:

• Country             Local Currency
• UAE                   AED
• Belgium            EUR
• China                CNY
• UK                    GBP

Create a currency display column:

Country Currency Display =

'DimLegalEntity'[Country] & " (" & 'DimLegalEntity'[LocalCurrency] & ")"

If this helps, ✓ Mark as Kudos | Help Other