Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
IgorM
Frequent Visitor

Show in a card a filter applied on chart

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.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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!!👍

 

 

View solution in original post

2 REPLIES 2
PaulDBrown
Community Champion
Community Champion

@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





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Anonymous
Not applicable

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!!👍

 

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors