You have a field named Region in a data source Region contains the following values:
North -
East -
South -
West -
You need to ensure that Region always sorts in the order of East, South, North, and West when placed onto any worksheet.
What should you use?
To ensure the Region field always sorts in the specified order (East, South, North, and West) on any worksheet, you should use the Default Properties of the field from the Data pane. Setting the default sort order in the Data pane ensures the specified order is applied consistently across all worksheets, regardless of any local settings such as axis sort indicators or legend sort menus which are specific to individual visualizations.
D should be the answer. The Question mentions field in the Data pane, also the Field not in the view yet, so no legend created.
we need to sort before placed on to sheet so that it will be sorted as per mentioned in questions. so D is the answer
only 'Default Properties' affect all worksheets
D. The Default Properties of the field from the Data pane