Skip to main content

Power XL Table v24.1 Release Notes

This topic describes the feature enhancements and resolved issues for Power XL Table v24.1.

Power XL Table v24.1 New Features

The following new settings are available in the Power XL Table visual.

Title

Description

Import Data

The Import Data option enables you to import you own data into the data table. This functionality operates similarly to the Table Editor visual.

Clear All Filters

The Clear All Filters button allows you to clear all column header filters in the visual.

Fetch More On Scroll and Lazy Load

The Lazy Load and Lazy Load Row Number settings enable you to customize your data on the visual table. By adjusting these values, you can control the number of rows displayed in the visual. For example, if you prefer to view only 100 rows in the data table, set the Lazy Load Row Number to 100. The visual will then show precisely those 100 rows, and you can access additional rows by scrolling down.

Discard Layout Changes After Visual Reload

The Discard Layout Changes After Visual Reload setting allows you to specify your data-saving preference. If the setting is set as ON, any unsaved data within the visual will be discarded if you apply a filter, change a slicer, or make any other modifications to the visual.

Power XL Table v24.1 Features Enhancements

Title

Description

New design on the layout and pop-up windows

New designs have been applied to buttons and pop-up windows, adhering to insightsoftware standards. Furthermore, you can also customize the formatting of these elements using the ‘External Stylesheet’ property.

Changing the default value of Display Operation Buttons property

The default value of Display Operation Buttons As setting has been changed to Labels.

Power XL Table v24.1 Resolved Issues

Title

Description

Hyperlink on other sheet

 

Performance of the formula

 

Data validation formula vs inserting a new row

 

Calculated columns and conditional formatting after column order change

The Calculated columns and conditional formatting persist even after reordering the columns.

Column sorting save

Column sorting can be saved now.

The order of the column header filters' values

The values of column header filters are now displayed in alphabetical order.

Scrolling after releasing the mouse button outside

Scrolling is now enabled when the left mouse button is released outside of the visual.

Insert button now became disabled

The Insert button is now disabled when the Enable Add setting is turned OFF within the Power BI settings.

Add Link, Remove Link and Add Image buttons in Legacy Rich Text Editor

In the Legacy Rich Text Editor, the Add Link, Remove Link, and Add Image buttons have been removed.

Known Limitation: Links and Image links are not supported within the Legacy Rich Text Editor.

Keeping filters after export to Excel

Column filters persist even after exporting to Excel.

Apply Filters to Entire Report with selecting a cell in the data table

The issue related to Apply Filters to Entire Report filtering when selecting a cell in the data table has been resolved.

Fixed the validation issue within inserted rows in case of the Validate All Records is OFF

The validation issue within inserted rows has been resolved when the Validate All Records setting is set as OFF.

Fixed the performance issue with loading in case of the Validate All Records is OFF

The performance issue related to loading has been resolved when the Validate All Records setting is set as OFF.

Total Row List enabled is not saved

The Total Row List is now correctly saved and remains intact even after reloading or switching pages.

Context menu/Delete on other sheets

The Context menu/Delete is now enabled on the other sheets.

Wrap text on the whole data table

The Wrap text is now applied to the whole data table.

CUBE.FILTER with Table Editor's selection.

The CUBE.FILTER formula now functions seamlessly with the Table Editor’s selection.

Weird behavior of cell states formatting

Previously, there were instances where formatting applied to cell states affected unrelated cells when users saved a value in the data table. However, this issue has now been resolved.

Row heights in Form view

In Form view, the row height now remains unchanged even after pressing the ENTER or ESC button.

Datetime picker no longer appears upon double-clicking a Total Row.

Previously, double-clicking on a Total Row cell within a Date type column would activate the Datetime picker. However, this behavior has been updated, and the Datetime picker no longer appears.

After exporting to Excel, columns with the IFISROWDIRTY formula got empty

When exporting data to Excel, columns containing the IFISROWDIRTY formula now function as expected.

Was this article helpful?

We're sorry to hear that.