Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
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 leaves the lines blank, when I search for it independently if it has data, so I don't know what is wrong.


Example Attachment


If anyone can help me to know what needs to be corrected please

Greetings, I look forward to the answers

2 Replies

  • 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
      Helper 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.