Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Individual Slicer selection - dynamic

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 in...
Need Help
  • v-cazheng-msft's avatar
    v-cazheng-msft
    5 years ago

    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's avatar
KasperBI
Frequent Visitor
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

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.