Hidden data items

Each dashboard element in the “Data Items” field contains an additional field – “Hidden Data Items”:

Elements of this field can be used as a context.

Let us consider it on an example of one of the previous tables:

We display the 7 best values of the “Order Count” measure for each product category only for year 2018. For this, drop the “Calendar Year” hierarchy into the “Hidden Data Items” field:

Now, from the context menu (by a right-click), select “Edit Filter” icon:

In the drop-down list, select the “Calendar Year” hierarchy:

And then specify the year:

Now the table displays the 7 best values of the “Order Count” measure for each product category for year 2018 only: