Update all row styles, with or without conditions - Profitbase/PowerBI-visuals-FinancialReportingMatrix GitHub Wiki

You can customize the appearance of all rows at once, or use conditions to only apply to some rows.

To customize all row, perform the following 4 steps:

  1. Ensure you are in Edit mode.
  2. Right click above the row header
  3. Select the style you want to apply
  4. Write the condition to chose which rows you want to apply the style to (optional)

image

Now everything has a grey background, because that's how style Custom1 has been defined in this example: image

Add a condition, like: "RowLevel()==1" and the style will only be applied to rows on level 1: image

You can also reference the value of other columns. For instance, only apply the style where the value of "Is Cost" is greater than 0:

image

Using && or || will allow you do add multiple conditions at once.

Then you can hide the "Is Cost" - column, so it doesn't show in the report: image