Forum Discussion

Machercoles's avatar
Machercoles
Frequent Visitor
2 years ago
Solved

Machercoles

Hola, necesitaria saber como puedo tener un cuadro de texto o algo similar, donde pueda ver los filtros aplicados en el informe.

 

Gracias por adelantado

 

  • You can visualize the applied filters in a Power BI report by using visual-level, page-level, or report-level filters in the Filters pane. However, if you want to display the applied filters within a text box or a similar visual within the report, there isn't a direct feature in Power BI to achieve this.

    You may need to create something like below : 

     

    SelectedValue =
    IF (
    ISFILTERED('YourTable'[YourColumn]),
    CONCATENATEX ( VALUES ( 'YourTable'[YourColumn] ), 'YourTable'[YourColumn], ", " ),
    "No filter applied"
    )

    and display the result in a card.

     

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Machercoles ,

     

    Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please feel free to let me know.

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

  • mchercol's avatar
    mchercol
    2 years ago

    El problema se resolvio. Pero lo que pasa es que tengo aplicados como 4 o 5 filtros.

    Deberia anidarlos?

    Se puede?

    Gracias por adelantado

    Disculpa la demora

3 Replies

  • You can visualize the applied filters in a Power BI report by using visual-level, page-level, or report-level filters in the Filters pane. However, if you want to display the applied filters within a text box or a similar visual within the report, there isn't a direct feature in Power BI to achieve this.

    You may need to create something like below : 

     

    SelectedValue =
    IF (
    ISFILTERED('YourTable'[YourColumn]),
    CONCATENATEX ( VALUES ( 'YourTable'[YourColumn] ), 'YourTable'[YourColumn], ", " ),
    "No filter applied"
    )

    and display the result in a card.

     

    • mchercol's avatar
      mchercol
      Helper I

      El problema se resolvio. Pero lo que pasa es que tengo aplicados como 4 o 5 filtros.

      Deberia anidarlos?

      Se puede?

      Gracias por adelantado

      Disculpa la demora

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Machercoles ,

     

    Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please feel free to let me know.

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.