Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

Filter no Filter

Hello everyone I need help with a filter that's working incorrectly When using the filter it leaves me all the values in the table and for the values that do not correspond to what was filtered it ...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi PVVBl00 ,

Base on your description, it seems like the data on the visual can't change dynamically base on the filter. Could you please provide provide some raw data in your table(s) (exclude sensitive data) with Text format, the applied filters and your expected result with backend logic and special examples. It would be helpful to find out the solution. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

 

And it is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

PVVBl00's avatar
PVVBl00
Icon for Helper III rankHelper III
2 years ago

El caso seria como el siguiente, tenemos 2 tablas  : TBL_SALES - TBL-PRODUCTS

TBL_SALES   
ID_SALESID_PRODUCTID_CATEGORYTOTAL
1311200
2111500
3521200
485600

 

TBL_PRODUCT 
ID_PRODUCTNAME_PRODUCT
1TOY 1 
2TOY 2
3TOY 3 
4TOY 4

Ambas tablas estan relacionada segun el ID_PRODUCT

 

En la pestaña de modelo tengo una tabla principal donde se obtienen datos de ambas tablas

EJ:

SALEDATENAME_PRODUCTNAME_CATEGORYTOTAL

1

01/01/2024PRODUCT10GENERAL TOY´S 1500
227/03/2024PRODUCT 5FOODSTUFFS700
312/02/2024PRODUCT 8TEXTILES650
417/01/2024PRODUCT12METALS 

230

Y tengo filtros segun productos y categorias, pero ocurre lo siguiente: Yo filtro por la categoria GENERAL TOY´S, la tabla hace lo siguiente:

SALEDATENAME_PRODUCTNAME_CATEGORYTOTAL

1

01/01/2024PRODUCT10GENERAL TOY´S 1500
227/03/2024PRODUCT 5  
312/02/2024PRODUCT 8  
417/01/2024PRODUCT12 

 

Me muestra todas las ventas de igual manera y las que no correspoden con el filtro les oculta los valores.

El resultado que yo espero al filtrar es el siguiente: 

SALEDATENAME_PRODUCTNAME_CATEGORYTOTAL

1

01/01/2024PRODRUCT10GENERAL TOY´S 1500

 

Espero se entienda, quedo atento ante cualquier duda
Saludos.