Reply
po Regular Visitor
Regular Visitor
Posts: 37
Registered: ‎09-24-2018
Accepted Solution

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

 

 


Accepted Solutions
Community Support Team
Posts: 7,295
Registered: ‎05-02-2017

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.

View solution in original post


All Replies
Community Support Team
Posts: 7,295
Registered: ‎05-02-2017

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.
Highlighted
po Regular Visitor
Regular Visitor
Posts: 37
Registered: ‎09-24-2018

Re: Breadcrumb with slicer selection

Hi,

 

Thanks for reply- you suggested solution works great.