Forum Discussion
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 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
3 Replies
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.
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 ZhiIf this post helps, then please consider Accept it as the solution to help the other members find i
adavid999 , not very clear
Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0Mmeasure slicer
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://www.youtube.com/watch?v=vlnx7QUVYME
