-
Notifications
You must be signed in to change notification settings - Fork 23
Update all row styles, with or without conditions
Anders Aano edited this page Jun 24, 2022
·
1 revision
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:
- Ensure you are in Edit mode.
- Right click above the row header
- Select the style you want to apply
- Write the condition to chose which rows you want to apply the style to (optional)
Now everything has a grey background, because that's how style Custom1 has been defined in this example:
Add a condition, like: "RowLevel()==1" and the style will only be applied to rows on level 1:
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:
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:
- Home
- Security
- Getting started
- Adding data to the visual
- Title
- Column styling
- Row expansion
- Row and Column totals
- Column expansion
- Values options
- Custom subtotals - rows
- Row styles - appearance
- Hiding rows
- Hiding columns
- Hide empty rows
- Formatting
- Custom columns
- Overriding column calculations
- Ragged hierarchies
- Web URL
- Applied steps
- Data Bars
- Export to Excel
- Thousand and Decimal Separator
- Measure Placement
- Calculations
- Theming
- Find Visual Version