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 Selec...
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

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

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