Pivot slicer link to heading

[adavid999]

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 worksheet? And if so, how? I tried copying pivot table and removing all fields except relevent region selction field but the slicer selection doesn't change the list, all regions are shown (it's just the averages/measures that change relevant to each selection). I am sure there is something simple I am missing!

Thanks,

A

[amitchandak]

@adavid999 , not very clear

Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M

measure slicer
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...
https://www.youtube.com/watch?v=vlnx7QUVYME

[adavid999]

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]

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