Show in a card a filter applied on chart

[IgorM]

Hi,

I have a page with a slicer at the top, for products, filtering 4 charts on that page. Each chart (stacked area chart) shows data for a different country - a visual level filter is applied on each chart. I would like to add a kind of a title to each chart that would show applied country filter. I managed to add a card to my page that shows currently applied product filter (from slicer) but I don't seem to be able to link a card to a chart so that it shows the applied country filter.

I realise that, since the country filters on chart are rather static, I could add a text box and type the countries into the text box, but I'd like to make it a bit more dynamic.

[PaulDBrown]

@IgorM 

You can try creating a measure along the lines of (assuming you are using 'Country Table [Country] as your filter - if not substitute accordingly) :

filtered countries =

VAR CountryFilter = CONCANTENATEX( Country Table, Country Table[Country], ", ")

RETURN

"Values for the following countries: " & CountryFilter

You can then select the chart, go to the format pane, select "Title" and in the title text options select the fx and add the [filtered countries] as the title value

[Anonymous · Accepted solution]

Hi @IgorM 
you can create a measure and make the headers dyanmic to whichever country selected

--Measure = CONCATENATE("The country is ",SELECTEDVALUE(Orders[Region],"Not yet selected"))

Change:Orders[Region] as per your column name

Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos, Press the thumbs up button!!👍