Forum Discussion

mgiardini's avatar
mgiardini
Frequent Visitor
10 months ago

Bug: Filter selections are cleared when using the search box in slicers with "Apply filter" enabled

Hi everyone,

when using the "Apply filter" option in Power BI, slicers allow users to select multiple values and then apply them all at once. However, if a user uses the search box inside a slicer before clicking Apply filter, all previously selected values are unexpectedly lost.
This behavior seems unintended, as it breaks the expected workflow: users should be able to search within slicer values without losing previous selections.

 

Can you help me to understand if it's a bug or not and if someone have a solution?

Thanks

 

Need Help

11 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 months ago

    prueba cargando el complemento de lupa, con esto no deberias tener problemas en hacer sub-busquedas dentro de datos filtrados y segmentados por otras variables.

  • mgiardini's avatar
    mgiardini
    Frequent Visitor
    10 months ago

    Thanks Sanzvalb,

    just for context I'm referring to this one here below. If I selected something, without clicking apply all filters, and then search for another field to filter, Apply all filter will not work on the first One.

    Example: I'm selecting Allan Guinot, from District Manager, then use the search filters to search for FiscalMonth, and selecting a month. When I click Apply all Filters, will only apply the filter on FiscalMonth.

    If you're not using the search filters work just fine.

     

    Thanks

     

    • v-menakakota's avatar
      v-menakakota
      Icon for Community Support rankCommunity Support
      10 months ago

      Hi mgiardini ,
      Thanks for reaching out to the Microsoft fabric community forum.

       

      when you use the search box in the filter pane and select values without clicking Apply all filters, the first selection gets cleared.

      It looks like this might be a limitation with the current “Apply filter” option. You can try clearing the search box before clicking Apply all filters to see if that helps.

       

      If I misunderstand your needs or you still have problems on it, please feel free to let us know. 

      Best Regards, 
      Community Support Team 

      • v-menakakota's avatar
        v-menakakota
        Icon for Community Support rankCommunity Support
        10 months ago

        Hi mgiardini ,

        I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

        Best Regards, 
        Community Support Team 

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 months ago

      repasando lo que me indicaste la vez anterior, hay un detalle aqui tu quieres en realidad es hacer una busqueda cartesiana (es decir buscar sobre datos sub filtrados ); entonces naturalmente no se alcanza; para esto ese modelo deberias tener 2 o mas tablas anidadas para lograr lo que pretendes, y en tu lienzo tengas N filtros para las condiciones multiples que planteas hacer.  y asi tener un set de datos ...  no es una buena practica esto... si bien PBI manipula datos no es un motor de base de datos.   aqui lo que te sugiero es por ejemplo desde SQL/MY SQL  o el motor que sea (donde si podras hacer sub-query que sean columnas bajo las condiciones que necesites.  armes un SP ó WV que ya contenga los datos mas procesados ;  de ultima redefine el alcance de esa visualizacion.