Forum Discussion

po's avatar
po
Icon for Post Prodigy rankPost Prodigy
7 years ago
Solved

Breadcrumb with slicer selection

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

 

 

Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    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 )
)

    Breadcrumb-with-slicer-selection

     

    Best Regards,
    Dale

3 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    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 )
)

    Breadcrumb-with-slicer-selection

     

    Best Regards,
    Dale

    • po's avatar
      po
      Icon for Post Prodigy rankPost Prodigy
      7 years ago

      Hi,

       

      Thanks for reply- you suggested solution works great.

       

       

    • diskovered's avatar
      diskovered
      Icon for Helper III rankHelper III
      7 years ago

      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 )
)