Forum Discussion
How to make a title with multiple slicer values using conditional formatting for visual titles
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:
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?
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
2 Replies
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
Thank you Anonymous! That works perfectly!
