cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kstachkunas Regular Visitor
Regular Visitor

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

 

I have a Filter that contains approx 8 values ...   as shown by ... below ... I would like the Visual Table below it to show something like "Selected Subject Categories: Carriers , Plant " 

 

It  will show if I only select one ... 

 

I did see the one where they Similiar Question wanted something from a slicer than all the Stacked columns  

 

Filter.PNG

Thanks for any help ...

Kathy

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
ChrisHaas Established Member
Established Member

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

@kstachkunas , try this DAX measure:

 

Dynamic Title =
VAR Part1 = "Selected Subject Categories: "
VAR Part2 =
    IF (
        ISFILTERED ( TableName[Subject Categories] ),
        CONCATENATEX (
            VALUES ( TableName[Subject Categories] ),
            TableName[Subject Categories],
            ", "
        ),
        "All"
    )
RETURN
    Part1 & Part2

This first checks to see if the user filtered that column.  If they didn't, return "Selected Subject Categories: All".  

 

If they did, it will return the list separated by a comma.  Bear in mind if they select more than 3, this title may be too big.  There is a way to display "Selected Plant, Carriers, and 3 more..." if that is necessary.  Since you have a small amount of values, I think you're ok.

 

Cheers,

 

~ Chris

 

 

2 REPLIES 2
Super User
Super User

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

Sure.  Your measure would look like this:

 

TableTitle = "Selected Subject Categories:  
" & CONCATENATEX(data_table, [category], ", ")
Highlighted
ChrisHaas Established Member
Established Member

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

@kstachkunas , try this DAX measure:

 

Dynamic Title =
VAR Part1 = "Selected Subject Categories: "
VAR Part2 =
    IF (
        ISFILTERED ( TableName[Subject Categories] ),
        CONCATENATEX (
            VALUES ( TableName[Subject Categories] ),
            TableName[Subject Categories],
            ", "
        ),
        "All"
    )
RETURN
    Part1 & Part2

This first checks to see if the user filtered that column.  If they didn't, return "Selected Subject Categories: All".  

 

If they did, it will return the list separated by a comma.  Bear in mind if they select more than 3, this title may be too big.  There is a way to display "Selected Plant, Carriers, and 3 more..." if that is necessary.  Since you have a small amount of values, I think you're ok.

 

Cheers,

 

~ Chris

 

 

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.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 203 members 1,905 guests
Please welcome our newest community members: