Filters on Tooltips

Question

Hi,&nbsp;I have the following pages on my power bi repot&nbsp;Page 1 - Page 1 has a filter on its page to only show data where the Section = HRPage 2 - Page 2 has a filter on its page to only show data when Section = Finance&nbsp;{Where Section is just a choice column in sharepoint with values HR, Finance, IT, Marketing}&nbsp;Each page has line stacked chart show data from its correspoding section. (Data and Year on X axis and value on y axis)&nbsp;I want to create a custom tooltip to show additioanl info.&nbsp;&nbsp;I created a tooltip page and created a basic table to show all info&nbsp;e.g.&nbsp;The table on the tooltip page looks like&nbsp;&nbsp;Section&nbsp; &nbsp; &nbsp;| Value&nbsp;HR&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | 10Finance&nbsp; &nbsp; &nbsp;| 14Marketing | 12&nbsp;etc&nbsp;The tooltip kind of works, but i would like to autoamtically filter depending on what page you are on.&nbsp;&nbsp;so if you are on the HR page, i would like the tooltip to only show HR Values. If you are on the Finance Page, i would like to Tooltip to only show Finace values.&nbsp;&nbsp;At the moment, when you hover over the month, it shows everything from all sections.&nbsp;&nbsp;Can someone assist me in getting the tooltop to filter based on the page.&nbsp;&nbsp;I tried the 'Keep All Filters' toggle on the toolip page, but then shows blank tooltip on each section page.&nbsp;&nbsp;Thanks in advance

amitchandak · Answer

PPStar , the section of measure should filter based on the same filter you use on page. 
&nbsp;
Assume the filter is page name
&nbsp;
calculate([Value measure], filter(Table, Table[Section] = selectedvalue(Page[Name]) )

nikhilchenna · Answer

Hi&nbsp;PPStar&nbsp;,For this you have to you selectedvalue function in you measure which is being used in the tooltip page calculation.&nbsp;Refer this link for more infor on selectedvalue,&nbsp;https://learn.microsoft.com/en-us/dax/best-practices/dax-selectedvalue&nbsp;Regards,Nikhil Chenna&nbsp;Appreciate with a Kudos!! (Click the Thumbs Up Button)Did I answer your question? Mark my post as a solution!

ppstar · Answer

i dont understand this.&nbsp;what is value measure?.&nbsp;

nikhilchenna · Answer

Hi&nbsp;PPStar&nbsp;,&nbsp;Use this below measure,&nbsp;Section&nbsp; &nbsp; &nbsp;| Value&nbsp;HR&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | 10Finance&nbsp; &nbsp; &nbsp;| 14Marketing | 12&nbsp;Measure = calculate(SUM([Value]), filter(Table, Table[Section] = selectedvalue(Page[Name]) )&nbsp;Regards,Nikhil Chenna&nbsp;Appreciate with a Kudos!! (Click the Thumbs Up Button)Did I answer your question? Mark my post as a solution!&nbsp;

ppstar · Answer

OK, i got the first part, dont understnad the second part SelectedValue(Page[Name]))&nbsp;The SelectedValue is looking for a column Name when i enter page its greys out, do i have to hardcode the page name?&nbsp;apologies for the basic questions, im a newbie.&nbsp;

Forum Discussion

Filters on Tooltips

7 Replies

Related content

Tooltip page

Calculate Tooltips

filter through context on tooltip

Map visual Filtering - Tooltip

Filtered Tooltip