Forum Discussion

vsslasd1's avatar
vsslasd1
Icon for Helper III rankHelper III
5 years ago
Solved

Display Filtered Criteria in One Single HTML Box Banner at the Top of PowerBI report

Hello,  I would like to display the filtered criteria in an HTML Text Box at the top of my report so we can see the specific data that it is filtered to. This would be a short version of what I woul...
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi vsslasd1 ,

     

    According to my understanding, you want to display all selected/filtered value,right?

     

    Method1:

    You could create a text box and use Q&A to display simply:

     

    Method2:

    Use CONCATENATEX() function together with ISFILTERED() to create measureslike this:

     

    filter country =
    "Country: "
        & IF (
            ISFILTERED ( 'Table'[Country] ),
            CONCATENATEX ( ALLSELECTED ( 'Table'[Country] ), 'Table'[Country], "," ),
            "All"
        )
    filter city =
    "City: "
        & IF (
            ISFILTERED ( 'Table'[City] ),
            CONCATENATEX ( ALLSELECTED ( 'Table'[City] ), 'Table'[City], "," ),
            "All"
        )

     

    Then use Multi-row Card visual ,the final output is shown below:

     

    Please take a look at the pbix file here.


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