Disconnected Slicer to slice a table

So I have a table that contains some information about services, like this: Service Value Chain Service Level ABC Ops, HR Bronze DEF IT, Ops Gold GHI IT, HR Silver JKL HR,...

Need Help

rohit_singh
4 years ago
Hi pmay ,

Please try this, provided your disconnected slicer looks like

1) Create a measure that captures the selected value from your disconnected slicer

SelectedChain = SELECTEDVALUE(dim_slicer[Value])

2) On your main table, create a measure that acts as a flag to display 1 when the selected value is found within the column

SelectFlag =

var _sel = dim_slicer[SelectedChain]

var _chain = MAX(DisconnectedSlicer[Value Chain])

RETURN
IF(CONTAINSSTRING(_chain, _sel), 1 , 0)

This will give you the following result. When you've selected "IT", all rows within column "Value Chain" that have value "IT" will be assigned a value of 1.
In the final step, add measure "SelectFlag" as a visual level filter to the table and set value to 1. This will show you only those rows that have values "IT"

Kind regards,
Rohit

Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 😊