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

[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