cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
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], ", ")
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.

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: 114 members 1,256 guests
Please welcome our newest community members: