How to make a title with multiple slicer values using conditional formatting for visual titles

[cbartusiak]

With the new April 2019 release, I see that I can make a title using a dax forumal when clicking on conditional formatting. I undertand how to create a title that returns a single item from slicer 1 and then a single item from slicer 2.

The formula for the measure I've been using is:

Rubric View Stacked Bar Chart Title = SELECTEDVALUE(learning_outcome_reults_rubric_view[college]) & " for " & SELECTEDVALUE(learning_outcome_reults_rubric_view[enrollment term])

However, I want to to create a title on my stacked bar chart where I can have the selected college from slicer 1 followed by multiple enrollment terms I have selected for slicer 2. For instnace, within the college of business, I would like to see in the chart title "College of Business for 2018-2019 - Fall I GR Evening, 2018-2019 - Fall II GR Evening, 2018-2019 - Spring I GR Evening, 2018-2019 - Spring II GR Evening". Is there any formula to be able to write this and split up the selected values by a comma?

[Anonymous · Accepted solution]

@cbartusiak -

You could use the function CONCATENATEX, like this:

Rubric View Stacked Bar Chart Title = 
SELECTEDVALUE(learning_outcome_reults_rubric_view[college]) & 
" for " & 
CONCATENATEX(
  values('learning_outcome_reults_rubric_view'[enrollment term]),
  [enrollment term],
  ", "
)

Cheers!

Nathan

[cbartusiak]

Thank you @Anonymous! That works perfectly!