General settings

Adjust general display options to modify the report’s look and feel.

The general display settings are used to customize the appearance of the report.

In the Lumel EPM toolbar, navigate to Settings > Appearance to open up the settings side panel.

Appearance 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.

Configure background color

ii) Text

You can change the color of the text/values in the visual using this option.

Configure text color

iii) Header text

You can change the color of the header text in the visual using this option.

Configure header text color

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.

Configure outline

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.

Highlighting row 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.

Highlighting alternate rows

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.

Showcasing reset to default option

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.

Applying highlight only to 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.

Applying major gridlines

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

Options of horizontal gridlines

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.

Applying minor horizontal gridlines

Skip lines

This option allows you to set the minor grid line gap between the rows.

The minimum and maximum skip line values are 1 and 10 respectively.

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.

The color of the header gridline is the same as that of the horizontal gridlines by default.

Header colour is set

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.

Applying minor vertical gridlines

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.

Default options of custom date format

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

Showcasing custom option

Setting up customized date format

6. Localization settings

You can configure translations in Lumel EPM 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.

Localization tab

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.

Configuring Localization

Step 4: Insert a static or data input row, then use the GETLOCALELABEL function in the Title field by passing the key defined in the translation configuration.

Using GETLOCALELABEL function

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

Kingfisher in German

Similarly, you can insert a calculated or formula row and use GETLOCALELABEL function in the Title field. The image below shows the report interface for a user in France.

Kingfisher and Brocode in French

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

Ensure that the key specified in the GETLOCALELABEL function is configured in the Localization settings with the required translations.

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.

In this section, we covered the general display settings. Navigate to the next section to learn more about hierarchy settings.