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

[vsslasd1]

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 would like to display. Altogether, there are about 10 fields that I want to display. 
What is the best method to do this ? 

ReptFilterCriteria = "Contract: <p><b><font color=blue>"&"445" & "</b></font><p>Customer and Location: <p> Start Date: Expiration Date: <p><b><font color=blue>"

Thank you!

[Anonymous]

Hi @vsslasd1 ,

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.😀

Best Regards,
Eyelyn Qin

[Anonymous · Accepted solution]

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.

[amitchandak]

@vsslasd1 , Not very clear. If it is a measure

ReptFilterCriteria = "Contract: <p><b><font color=blue>"&"445" & "</b></font><p>Customer and Location: <p> Start Date: Expiration Date: <p>" & selectedvalue(Date[Date])&"<b><font color=blue>"