Pivot sorting using filter pane

[the-null]

Hi,

How can I add measures, such as Quantity 1 and Quantity 2, to a filter pane? However, I want them to be displayed as 'Quantity 1' and 'Quantity 2' within the filter pane, and when I select one of these values, I want the data within the pivot table for Quantity 1 to be sorted from largest to smallest.

[LRuCelver]

You need to add a field that has the names of your measures.

You can check whether a value is selected by using SubStringCount and GetFieldSelections.

Create an expression for the sorting of every measures in the table.

[the-null]

ok, can you give an example or something?

I don't understand what you exactly mean.

[LRuCelver · Accepted solution]

You can create the field in the script:

MeasureSelect:
NoConcatenate Load * Inline [
	SelectedMeasure
    Quantity 1
    Quantity 2
];

This expression returns 1 if in this case 'Quantity 1' is selected and 0 if not:

Coalesce(SubStringCount(GetFieldSelections(SelectedMeasure, '|'), 'Quantity 1'), 0)