cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
IgorM
Regular 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
HusnaBanu413
Super User II
Super User II

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
Super User II
Super User II

@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.






HusnaBanu413
Super User II
Super User II

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors