Forum Discussion
Display Filtered Criteria in One Single HTML Box Banner at the Top of PowerBI report
- Anonymous5 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.
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.