Apologies @Greg for my poor etiquette and jumping in on this one, thought I could help.
@Ravi85 - my suggestion would’ve worked if you’d just required a small text output and this could’ve been done as per @MudassirAli did in his Power BI Challenge 7 entry, link below. If you hover over certain KPI’s they replace as text.
Your requirements seem to involve returning a large table for each.
Unless you create a ToolTip page for each header, insert an object over the header and then use the visual header ToolTip to return your table. I’m not able to replicate just now or if that would work as you require. Do you follow what I’m suggesting?
Power BI Challenge 7 - Purchases, Inventory And Sales! - Power BI Challenges - Enterprise DNA Forum