cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
po Member
Member

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Breadcrumb with slicer selection

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Community Support Team
Community Support Team

Re: Breadcrumb with slicer selection

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
po Member
Member

Re: Breadcrumb with slicer selection

Hi,

 

Thanks for reply- you suggested solution works great.

 

 

diskovered Regular Visitor
Regular Visitor

Re: Breadcrumb with slicer selection

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