Forum Discussion

adavid999's avatar
adavid999
Icon for Helper V rankHelper V
6 years ago

Pivot slicer link to heading

Hi I have pivot tables with calculated measures that change on slicer selection (e.g. an average for region a, region b etc).   Can I show slicer selection (region) as heading in a cell on my works...
Need Help
adavid999's avatar
adavid999
Icon for Helper V rankHelper V
6 years ago

ps I figured it out. Deleted slicer and reinserted pivot table from correct lookup table, duplicated it and used slicer/pivot selection as header using cell ref.

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi adavid999 , 

    It seems that you solve this problem, right? If so and if you'd like to, you could mark corresponding post as answer or share your solutions. That way, people who in this forum and have similar issue will benefit from it.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find i