You are designing tables and columns for a Microsoft Power Platform solution The solution will contain an interactive experience dashboard. You need…

Interactive experience dashboards in model-driven apps allow for global filtering to provide a focused view of data across all visual components. According to official Microsoft documentation, only specific column data types are supported for this global filter functionality. The supported types are Choice (formerly Option Set), Choices (Multi-select Choice), Lookup, and Date and Time. Therefore, to ensure columns can be used as global filters, they must be created as either a Choice or a Lookup data type from the options provided.

A. Yes/No: This boolean data type is not supported for use as a global filter in interactive dashboards.

C. Text: Free-form text fields are not supported for global filters, which require a predefined set of values or records to filter by.

D. Multiline Text: Similar to single-line text, this data type is not supported for global filtering in interactive dashboards.

1. Microsoft Learn. (2023). Configure model-driven app interactive dashboards. In the section "Configure the filter entity and fields for the interactive dashboards," the documentation explicitly lists the supported field types for global filtering: "In the interactive dashboards, you can use the following fields for global filtering: Choice, Choices, Lookup, and Date and Time." This directly confirms that Choice and Lookup are correct and that other types like Text and Yes/No are not on the supported list. Link