Slicer Formula

[RanjanThammaiah]

Hi Team,

Weired but helpfull for me to create a dynamic Title.

I have 2 column which is "State" and "Jurisdiction". Can i create a combined slicer for this. Just to show"Select All","State"and "Jurisdiction"

This i just to give the reference to the dynamic title.

if i select any one of them the title should change accordingly.

In the below image you can see that 2 different slicer with respective details inclueded.

i wanted to see the slicer which shows only "State"and "Jusrisdiction" in the same without any individual details.

[v-cherch-msft · Accepted solution]

Hi @RanjanThammaiah 

You may create a slicer table with Distinct function first.Then create a measure like below.Attached sample file for your reference.

Measure =
IF (
    ISFILTERED ( 'Table'[Jurisdiction] ) || ISFILTERED ( Table1[Industry] ),
    SELECTEDVALUE ( Table1[Industry] ) & ","
        & SELECTEDVALUE ( 'Table'[Jurisdiction] )
)

Regards,