How to restrict slicer visual to select only 2 values

[sidd_xp]

I created a report with a slicer in it. The Slicer has 16 values like Q1_2018, Q2_2018 etc. What i want help in, is to restrict the slicer to select only 2 values so that user can only see comparison between 2 quarters only out of 16.

[amitchandak]

@sidd_xp , you can display a message and make you data blank using visual level filter

if (countrows(allselected(Table[Column])) >2, "Select less values", Blank())

Check this measure blank in all visuals and display message on a card

[sidd_xp]

Thanks, this is a good walkaround, i tried and its working fine. But what if in place of Blank(), i want to show the exact 2 values which are selected in card. How can i do that ?

[v-easonf-msft · Accepted solution]

Hi, @sidd_xp 

You can try function CONCATENATEX  to concatenate the values in slicer.

Measure1 = 
IF (
    COUNTROWS ( ALLSELECTED ( DateTable[Year Quarter] ) ) > 2,
    "Select less values",
    CONCATENATEX (
        VALUES ( DateTable[Year Quarter] ),
        DateTable[Year Quarter],
        " vs "
    )
)

Best Regards,
Community Support Team _ Eason