Skip to main content




¿Cómo crear filters de nivel de página en Power BI con un ejemplo? Los filtros de nivel de página de Power BI son útiles para filtrar los gráficos (o elementos visuales) presentes en la página. Por ejemplo, si su página contiene cuatro gráficos, puede usar este filtro de nivel de página para filtrar esos cuatro informes a la vez.

How to create Power BI page level filters

Para demostrar los filtros de nivel de página en Power BI, usaremos el gráfico de columnas, el gráfico circular y los gráficos de bars que creamos en nuestra publicación anterior de Power BI.

power-bi-page-level-filters-1-8228371<>power-bi-page-level-filters-1-8228371

In the Filters section, you can see the list of page-level filters available in Power BI. You have to use the Page level filters section to create a page-level filter.

power-bi-page-level-filters-2-3292688

Let me drag and drop the English country region name from the fields section to the page level filters.

power-bi-page-level-filters-3-8566918

Expand the name of the country region in English to see the filter types. By default, the Basic Filters option selected as the Filter Type.

power-bi-page-level-filters-4-2588660

For the purpose of demonstration, let me select Australia, Germany, the United Kingdom, and the United States. In the following screenshot, you can see that the column chart shows the sales for the selected countries. The pie chart shows the selected countries. And, the bar chart shows the states that belong to these countries.

power-bi-page-level-filters-5-9595110

Use the drop-down menu to change the filtering type to Advanced filter.

Aquí, estamos aplicando varios filtros en la columna País. El primer filtro comprueba si el país contiene una keyword unificada o no. O bien, la segunda condición comprueba los países que no comienzan con F.

power-bi-page-level-filters-6-6822014

The next page shows the countries that contain the United keyword, and the countries do not start with F.

power-bi-page-level-filters-7-8150609

Let me remove the existing page level filters in Power BI and drag and drop the Product Color section of the fields onto the page level filters.

power-bi-page-level-filters-8-9463916

Select the colors blue, red, silver, and yellow as the basic filter fields.

In the screenshot below, you can see that the column chart shows the sales amount for the selected colors. The pie chart shows the sales amount of the selected product colors, and the bar chart shows the sales amount of the selected colors.

power-bi-page-level-filters-9-2332162

Let me remove the existing page level filters and drag and drop the Sales Amount section of the fields to the page level filters. Then expand Sales Amount to see the filter options. See the article Filters on measures to understand these options.

power-bi-page-level-filters-10-2004458

For this Power BI page-level filter demonstration purpose, we select is greater than as operator and 3000 as value. All the reports on the next page show countries or states with a Sales Amount greater than 3,000.

power-bi-page-level-filters-11-6436281




¿Cómo crear filters de nivel de página en Power BI con un ejemplo? Los filtros de nivel de página de Power BI son útiles para filtrar los gráficos (o elementos visuales) presentes en la página. Por ejemplo, si su página contiene cuatro gráficos, puede usar este filtro de nivel de página para filtrar esos cuatro informes a la vez.

How to create Power BI page level filters

Para demostrar los filtros de nivel de página en Power BI, usaremos el gráfico de columnas, el gráfico circular y los gráficos de bars que creamos en nuestra publicación anterior de Power BI.

power-bi-page-level-filters-1-8228371<>power-bi-page-level-filters-1-8228371

In the Filters section, you can see the list of page-level filters available in Power BI. You have to use the Page level filters section to create a page-level filter.

power-bi-page-level-filters-2-3292688

Let me drag and drop the English country region name from the fields section to the page level filters.

power-bi-page-level-filters-3-8566918

Expand the name of the country region in English to see the filter types. By default, the Basic Filters option selected as the Filter Type.

power-bi-page-level-filters-4-2588660

For the purpose of demonstration, let me select Australia, Germany, the United Kingdom, and the United States. In the following screenshot, you can see that the column chart shows the sales for the selected countries. The pie chart shows the selected countries. And, the bar chart shows the states that belong to these countries.

power-bi-page-level-filters-5-9595110

Use the drop-down menu to change the filtering type to Advanced filter.

Aquí, estamos aplicando varios filtros en la columna País. El primer filtro comprueba si el país contiene una keyword unificada o no. O bien, la segunda condición comprueba los países que no comienzan con F.

power-bi-page-level-filters-6-6822014

The next page shows the countries that contain the United keyword, and the countries do not start with F.

power-bi-page-level-filters-7-1743186

Let me remove the existing page level filters in Power BI and drag and drop the Product Color section of the fields onto the page level filters.

power-bi-page-level-filters-8-9463916

Select the colors blue, red, silver, and yellow as the basic filter fields.

In the screenshot below, you can see that the column chart shows the sales amount for the selected colors. The pie chart shows the sales amount of the selected product colors, and the bar chart shows the sales amount of the selected colors.

power-bi-page-level-filters-9-8277795

Let me remove the existing page level filters and drag and drop the Sales Amount section of the fields to the page level filters. Then expand Sales Amount to see the filter options. See the article Filters on measures to understand these options.

power-bi-page-level-filters-10-4589647

For this Power BI page-level filter demonstration purpose, we select is greater than as operator and 3000 as value. All the reports on the next page show countries or states with a Sales Amount greater than 3,000.

power-bi-page-level-filters-11-9950100