Coloring some rows when using template ( Financial ) without using conditonal formating

[WimH]

Is it possible to give the total row fields ( some for example the nett result ) another color or line below without using conditonal formating

[BrianJ]

@WimH,

Welcome to the forum - great to have you here!

In answer to your question, go to the Subtotal and/or Total format settings:

Hope this is helpful.

• Brian

[WimH]

Brian thanks for the quick reaction, but Iám using a template ( income statement - imported from excel )

[BrianJ]

@WimH,

OK, let me take another swing.

This doesn’t meet your “no conditional formatting” constraint, but it’s a technique that lets you highlight any row or group of rows:

How to highlight Total Row

@Tahir, OK, I put together an example using Sam’s Financial Reporting Showcase data. Here’s the DAX for the Highlight calculated column for the two rows I chose to highlight: Highlight = SWITCH( TRUE(), 'Financial Categories'[Financial Statement List] = "COS - Equipment", 1, 'Financial Categories'[Financial Statement List] = "COS - Prize Fund", 1, BLANK()) Then just conditionally formatted each of the fields in the table based on the value of the Highlight column. The key i…

Hope this is helpful. If not, please post a sample PBIX and the outcome you want to achieve, and we’ll take another shot…

• Brian

[WimH]

Brian , Thanks that is just the solution i need.

[BrianJ]

@WimH,

Great - glad to hear that worked well for you.

• Brian