Individual Slicer selection - dynamic

[Anonymous]

Hi

I have 3 separate slicers, 7 days, 14 days and 28 days. I need the report title to show which of these is selected. If they were combined as a single slider I'd have no problem but as they are individual I need something to illustrate which one is selected before I can feed it into the dynamic title. Could anyone help? 

Thanks!

[v-cazheng-msft · Accepted solution]

Hi, @Anonymous 

You can try to use SELECTEDVALUE function to create Measure. If it doesn't work, please describe the structure of your tables, visuals used and expected result with more details.

Best Regards,

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[KasperBI]

Could you provide some more context? Such as the DAX-code for each slicer / data structure. My instinct here would be that it would be easier if it was not 3 individual slicers, but a single slicer instead to then feed into a dynamic title.

[Anonymous]

Agree.  However they have been created separately. The 3 slicers are comprised of 3 calculated columns that take last 7, 14, 28 days with everything else as 'Other'. So I filter each for each slicer to exclude 'other'. Each slicer is then a single button that filters the report accordingly. I'm trying to have one measure that includes the title text with an IF statement around the 3 slicers. Not yet successful with the DAX though.