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,
I required the Indidul day and everyday data. That means if i am selecting Monday then Monday & Every day related both need to show.
Hi Narukkp ,
In the formula I have provided when you select monday it will automatically return Monday and Everyday.
my questions was in the sense if you need for example to select Monday and Tuesday and return monday tuesday and every day?
- Narukkp6 years agoHelper V
Hi ,
MFelix Thanks for your reply. I have follow the same above proces like created the separate table for day slicer and create the filter measure but my requirement is not achived.
For your question if i am selecting Monday & tuesday then i required Monday, Tuesday and Everydata.