Forum Discussion
Slicer selection data
- Anonymous6 years ago
Hi Narukkp ,
Please check the following steps.
1# Create a calculated table and use it as silcer.
Table 2 = DISTINCT('Table'[day])2# Create the visual you want and create a measure then add it to the visual level filter = is not blank .
Measure = IF ( NOT ( ISFILTERED ( 'Table 2'[day] ) ), 1, IF ( SELECTEDVALUE ( 'Table 2'[day] ) = "everyday", 1, IF ( SELECTEDVALUE ( 'Table'[day] ) = "everyday" || SELECTEDVALUE ( 'Table'[day] ) = SELECTEDVALUE ( 'Table 2'[day] ), 1, BLANK () ) ) )Result would be shown as below.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Narukkp ,
Please check the following steps.
1# Create a calculated table and use it as silcer.
Table 2 = DISTINCT('Table'[day])2# Create the visual you want and create a measure then add it to the visual level filter = is not blank .
Measure =
IF (
NOT ( ISFILTERED ( 'Table 2'[day] ) ),
1,
IF (
SELECTEDVALUE ( 'Table 2'[day] ) = "everyday",
1,
IF (
SELECTEDVALUE ( 'Table'[day] ) = "everyday"
|| SELECTEDVALUE ( 'Table'[day] ) = SELECTEDVALUE ( 'Table 2'[day] ),
1,
BLANK ()
)
)
)Result would be shown as below.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Narukkp6 years agoHelper V
Thank you Anonymous . Perfect it is working as expected..