Forum Discussion

vsslasd1's avatar
vsslasd1
Helper 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 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!
Need Help
Show and Tell
Tips and Tricks
  • 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.

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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>"

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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