Hidden Data Items

• Jun 02, 2020
• 2 minutes to read

The hidden data items can be used to perform various data shaping and analysis operations by measures or dimensions that do not directly take part in the visual representation of data.

To add hidden data items, invoke the Binding menu, click the Add Measure / Add dimension placeholders in the Hidden Measures / Hidden Dimensions data section and select an appropriate data field.

You can perform the following operations using hidden data items.

• Filtering
• Sorting
• Top N
• Conditional Formatting

Filtering

You can use hidden dimensions to apply filtering to a dashboard item and measures.

For example, the Grid on the image below is filtered by the OrderDate (Quarter) hidden dimension:

Sorting

You can sort values of the specified dimension by the hidden measure.

For instance, a data item menu on the image above displays sorting by values of the hidden UnitPrice (Sum) measure.

Top N

You can use hidden measures in Top N conditions.

For example, a data item menu on the image above displays the top 5 categories for the UnitPrice (Sum) hidden measure.

Conditional Formatting

You can create format rules based on hidden measures to apply conditional formatting to elements corresponding to visible values.

For example, the Range Set format rule on the image above is calculated by the Quantity (Sum) hidden measure.