Dynamic text based on multiple filters

[Xilitor01]

Hello,

I have a Headline Text where I want to showcase what filters have been applied.

What I have:

What I am looking for (or something similar)

It shoul filter the headline text so it easy to see what filters have been made to the data.

The data/example is just sample data. On my actual page I have more than 10 different slicers, which is why I am looking for a solution to easily get an overview of what has been selected.

I hope someone can help 🙂

[BIHelper · Accepted solution]

Hi @Xilitor01 ,

You need to create this measure to get dynamic text.

Selection = Var City=CONCATENATE("City: ",SELECTEDVALUE(Sheet2[city ]))

Var Channel= CONCATENATE("Sales Channel: ",SELECTEDVALUE(Sheet2[sales Channel]))

return

CONCATENATE(CONCATENATE(City,", "),Channel)

This is the output came for my data

Thank You!
Mark this as solution if it satisfyies your requirement.

[amitchandak]

@Xilitor01 ,

You have to create a measure like

= "Country " & concatenatex(Table, Table[Country], " ," ) & "Postal Code" & concatenatex(Table, Table[Postal Code], " ," )

add others as per need

Concatenatex: https://www.youtube.com/watch?v=du2HSEzng2E&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=43

[Xilitor01]

Thanks for your reply!

Becauwe we'd have more than 10 filters it will not create a good overview of the selected slicers as it will always show Country, Postal Code, etc.

Is it not possible only to show the Slicers which have been selected?