Breadcrumb with slicer selection

[po]

Hi,

What is best way to capture slicer selections in power bi.

Have seen 

 IF(ISFILTERED('Suppliers Details'[CompanyName]), SELECTEDVALUE('Suppliers Details'[CompanyName], "Multiple Selections"), "No Selection")  but how can we best capture each and every selection in the slicer?

e.g Selected YearWks = 2018, 2019   Selected Product = Cereal...

Thanks

[v-jiascu-msft · Accepted solution]

Hi @po,

What's the expected result? There aren't many tricks. If you'd like to see the details, you can try the measure below.

Measure =
IF (
    ISFILTERED ( Table1[YearWks] ),
    CONCATENATEX ( VALUES ( Table1[YearWks] ), [YearWks], "-", 0 )
)

Best Regards,
Dale

[diskovered]

What if you have multiple slicers, same table for example, Year, Month, Quarter, Day, is it possible to concat all? What's the syntax?

Measure =
IF (
    ISFILTERED ( Table1[YearWks] ),
    CONCATENATEX ( VALUES ( Table1[YearWks] ), [YearWks], "-", 0 )
)

[po]

Hi,

Thanks for reply- you suggested solution works great.