Forum Discussion
fullstrum
4 years agoFrequent Visitor
Slicer uses different relationship for different visuals
Hello, I have a data structure similar to below: Iteration Table Iteration Version1/Sprint172 Version1/Sprint173 Version1/Sprint174 Version1/Sprint175 Feature Table ...
v-chenwuz-msft
Community Support
4 years agoHi fullstrum ,
You will need to import the Iteration Table again or duplicate the column, as the original relationship will allow slicer to filter the underlying table. Use the newly imported interation table as the value for the slicer visual.
Create two measures
PBIs_measure =
IF (
MAX ( [PBIsCompletedIn] )
= VALUE ( RIGHT ( SELECTEDVALUE ( 'COPY Iteration'[Iteration] ), 3 ) ),
MAX ( [PBIsCompletedIn] ),
BLANK ()
)
Bugs_measure =
IF (
MAX ( [BugsCompletedIn] )
= VALUE ( RIGHT ( SELECTEDVALUE ( 'COPY Iteration'[Iteration] ), 3 ) ),
MAX ( [BugsCompletedIn] ),
BLANK ()
)
And the result:
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.