# General settings The general display settings are used to customize the appearance of the report. In the Plan toolbar, navigate to **Settings > Appearance** to open up the settings side panel.

### 1. Canvas The canvas section contains options to set the overall appearance of the report. * **Background** * **Text** * **Header Text** #### i) Background You can change the background color of the canvas using this option.

#### ii) Text You can change the color of the text/values in the visual using this option.

#### iii) Header text You can change the color of the header text in the visual using this option.

### 2. Outline This option allows you to set the outline for the visual. If you enable this option, a color picker is enabled. The color picker allows you to select the color of the outline. We have set a blue outline for the grid below.

### 3. Row highlight This option allows you to highlight the rows in the report. The various row highlight options are: * **Row Hover** * **Row Alternate** * **Row Alternate Contrast** * **Row Alternate Flashy** * **Off** #### **i) Row hover** Highlights the row upon hovering over them. If you enable this option, the following options are displayed: **Row text color** - This option allows you to set the text color of the row on hover **Row background color** - This option allows you to set the background color of the row on hover In the image below, the row text color is set to pink, and the row background color to yellow on hover.

**ii) Row alternate -** Highlights alternate rows. All of the row highlight options are customized with predefined colors. By default, all the tables are configured with the **Row alternate** highlight option. If you enable this option, the following options are displayed: **Odd row** - This option allows you to set the color of the odd rows **Even row** - This option allows you to set the color of the even rows The row alternate highlight is shown in the below image.

**iii) Row alternate contrast -** Highlights the odd and even rows with contrasting color shades by default. If you enable this option, the **Odd row** and **Even row** options are displayed. You can also customize the colors to suit your requirements.

Highlighting rows using row alternate contrast

**iv) Row alternate flashy -** Highlights the odd and even rows with flashy color shades. If you enable this option, the **Odd row** and **Even row** options are displayed.

Highlighting rows using row alternate flashy

You can also customize it by changing the colors from the default settings. If you want to reset the colors to their default values, use the **Reset to default** option, as highlighted in the image below.

You can remove the row highlight by selecting the **off** option from the drop-down. Enable the ***Measure Only Highlight*** option to remove the highlight from the categories and highlight just the measures.

### 4. Gridlines #### **i) Major gridlines** Use this option to set major gridlines for the parent rows in the visual. You can select from the following values: * **Single -** This option will insert a single gridline to the parent rows * **Double -** This option will insert a double gridline to the parent rows * **Off** - This option will turn off the major gridlines If the **Single** or **Double** option is selected for the major gridlines, then a color picker is enabled. Using the color picker, you can customize the color of the single/double major gridlines. In the below example, **Double** major gridlines are inserted and their colors are set to blue.

If **Off** is selected, the major gridlines will not be displayed. This option is set to **Off** by default. #### ii) Minor gridlines You can add **Horizontal**, **Header**, and **Vertical** properties for minor gridlines. #### Horizontal This option lets you set the horizontal gridlines for child rows. You can select from the following options: * **Solid lines** * **Dotted lines** * **Off**

If the **Solid Lines** or **Dotted Lines** option is selected for the horizontal gridlines, then a color picker is enabled. Using the color picker, you can customize the color of the solid/dotted horizontal gridlines. You can also set the number of rows to skip between 2 consecutive lines. In the example, **Solid** horizontal gridlines are inserted, and their colors are set to blue. 1 row is skipped between lines.

#### Skip lines This option allows you to set the minor grid line gap between the rows. {% hint style="info" %} The minimum and maximum skip line values are 1 and 10 respectively. {% endhint %}

Applying minor dotted horizontal gridlines with skip lines as 2

#### Header This option lets you insert gridlines for the column headers. If this option is enabled, then a color picker option becomes available next to it. Using the color picker option, you can customize the color of the header gridline. {% hint style="info" %} The color of the header gridline is the same as that of the horizontal gridlines by default. {% endhint %}

If you change the color of the header gridline, the color of the horizontal gridlines also gets changed accordingly.

Color of header and minor horizontal gridlines

#### Vertical This option lets you insert vertical lines between columns. You can select from the following options: * **Solid -** This option will insert solid vertical lines to the right of each column. * **Off** - This option will turn off the vertical lines If the **Solid lines** option is selected for the vertical lines, a color picker option is enabled. Using the color picker, you can customize the color of the solid vertical lines. In the example, **Solid** vertical gridlines are inserted, and their colors are set to blue.

### 5. Custom date format You can set a specific date format for date dimensions in rows or columns. Enable the **Custom Date Format** option to select the format from the Date category dropdown. This option can be used for non-hierarchical date fields, flat date hierarchies, and Power BI date hierarchies.

You can specify individual formats for year, month, day, hour, minute and second by clicking on the **Custom** option in the **dates** dropdown.

### 6. Localization settings You can configure translations in Plan based on the language settings in Power BI/Microsoft Fabric. If your report has a global audience, you can configure calculated rows/columns or column groups to display dimension categories based on pre-defined translations when the language is switched. When users open the report in French or German, their row and column group headers automatically appear in their language-delivering a seamless experience. **Step 1:** Navigate to **Settings** > **Localization** Settings to create translation entries.

**Step 2:** Use the **Add New** option to add dimension or header names as keys along with their translations. Alternatively, you can also import an Excel file in the same format available in the **Localization** tab, which already includes all the required keys and translations. **Step 3:** After adding or importing the keys and its translations, click **Save**.

**Step 4:** Insert a [**static or data input row**](/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/insert-manual-input-rows.md)**,** then use the **GETLOCALELABEL** function in the **Title** field by passing the key defined in the translation configuration.

When a user in Germany opens the report, the 'Kingfisher' brand is translated into German.

Similarly, you can insert a [calculated or formula row](/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/insert-calculated-rows.md) and use **GETLOCALELABEL** function in the **Title** field. The image below shows the report interface for a user in France.

You can use the formula **GETLOCALELABEL('Key')** directly in column headers.

Using GETLOCALELABEL function in column headers

Notice how the brand names in the rows and 'Revenue' in the column header are implicitly changed to French.

Brand names in rows and the Revenue column header translated into French

{% hint style="info" %} Ensure that the key specified in the **GETLOCALELABEL** function is configured in the **Localization** settings with the required translations. {% endhint %} **FAQs** **Q1. How can I change the Regional/Language settings in Power BI/Microsoft Fabric?** To experience the Power BI/Microsoft Fabric interface in a different regional setting or language, change the language settings by referring to this [link](https://learn.microsoft.com/en-us/power-bi/fundamentals/supported-languages-countries-regions?source=recommendationshttps://learn.microsoft.com/en-us/power-bi/developer/visuals/localization?tabs=English). In this section, we covered the general display settings. Navigate to the next section to learn more about [hierarchy settings](/display-settings/hierarchy-settings.md). --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.fabricplan.com/display-settings/general-settings.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.