How to enable conditional formatting for specific rows / columns only? Like frogs here:

Let´s create a measure like this from related measure. The logic is – when working with selected row, calculate the number. Otherwise, show any text.

  • Conditional formating measure = IF(
       FIRSTNONBLANK(‘Table'[Item],0)=”Frogs”,
       SUM(‘Table'[Value]),
       “nothing”)

Then create new conditional formatting rule, using the measure.

Leave a Reply

Your email address will not be published.

*

clear formPost comment