cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
cbartusiak Frequent Visitor
Frequent Visitor

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:

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

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

@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

2 REPLIES 2
Super User
Super User

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

@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 Frequent Visitor
Frequent Visitor

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

Thank you @natelpeterson! That works perfectly!

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 353 members 3,192 guests
Please welcome our newest community members: