Forum Discussion
ponchibonos
Helper I
3 years agoTwo columns as segmentation
I have a table with two columns of responsibles of a Proyect. Is possible to slice my data with the two columns independently? For example: When I selected "Ale" the slicer shows the data in...
- Anonymous3 years ago
Hi ponchibonos ,
In addintion to lbendlin's reply, you need to create an unrelated DIMRESPONABLE table and then create a measure to filter your visual.
DIMRESPONSABLE = DISTINCT ( UNION ( VALUES ( 'Table'[RESONSABLE] ), VALUES ( 'Table'[RESONSABLE 2] ) ) )Measure:
Filter = VAR _SELECTED = VALUES ( DIMRESPONSABLE[RESONSABLE] ) RETURN IF ( MAX ( 'Table'[RESONSABLE] ) IN _SELECTED || MAX ( 'Table'[RESONSABLE 2] ) IN _SELECTED, 1, 0 )Add this measure into visual level filter and set it to show items when value = 1. Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
lbendlin
Super User
3 years agoYou need to use disconnected slicers if you want independent filters.