Ways to emphasize bottom rows of a table

[TestAccount321]

Hello. I'm looking for a method to emphasize the bottom two rows of a table display. The table has a filter on it for a single ProjectNumber. Then the data for that project is brought in. Regardless of the project data, the value of the first column of the last two rows will be the same. This allowed me to use conditional formatting by looking at the column value and changing the background color to try and emphasize it. As far as I can tell, you can only really change font color and background color for an individual row, not font size or Bold/italics.

I'm wondering if people have other ways to emphasize certain rows. I was thinking of breaking out these rows into cards so I could have more control over the formatting. However, the size of my table is not constant, it varies according to the project input. My understanding is that you can't dynamically place a card - it has to stay at the same spot you place it. This would leave gaps between my table and the cards or open the possibility that my cards would cover the table.
Also I have a requirement that the entire tables content should be visible, i.e. no scroll bar should appear

[v-agajavelly]

Hi @TestAccount321 ,

I hope the response provided helped in resolving the issue. If you still have any questions, please let us know we are happy to address.

Regards,
Akhil.

[v-agajavelly]

Hi @TestAccount321 ,

Checking in again were you able to apply the conditional formatting with the custom DAX measure? If it didn’t quite work or you ran into any blockers, I can share a detailed step-by-step guide along with the exact formula. Just let me know.

Regards,
Akhil.

[v-agajavelly]

Hi @TestAccount321 ,

Just following up did you get a chance to try the conditional formatting approach with the custom DAX measure? Happy to hear if it gave you the row-level highlighting you were aiming for, or if you’d like me to share the exact steps and formula I used.

Regards,
Akhil.

[v-agajavelly]

Hi @TestAccount321 ,

I used conditional formatting with a custom DAX measure to highlight specific rows. Changed the table preset to remove default styling and make the highlight more visible. Decided against cards because the layout didn’t work well with a dynamic table size. This approach worked well for me while keeping the report layout clean and consistent. Hope it helps! Let me know if you want the full formatting steps or the DAX measure I used.

Regards,
Akhil.

[danextian]

Hi @TestAccount321

The closest you’ll get is using conditional formatting on the background or text color, which you’ve already done. To make the last two rows stand out more, you could also change the preset style to Minimal or None. The tricky part now is figuring out how to identify the last two rows especially since the table can be sorted.

[amitchandak · Accepted solution]

@TestAccount321, You can choose a format with alternate rows. Now, when you do a conditional format on all fields (Table), all measures/values (Matrix), it will give a highlighted impression.