Filters on Tooltips

[PPStar]

Hi, 

I have the following pages on my power bi repot

Page 1 - Page 1 has a filter on its page to only show data where the Section = HR

Page 2 - Page 2 has a filter on its page to only show data when Section = Finance

{Where Section is just a choice column in sharepoint with values HR, Finance, IT, Marketing}

Each page has line stacked chart show data from its correspoding section. (Data and Year on X axis and value on y axis)

I want to create a custom tooltip to show additioanl info. 

I created a tooltip page and created a basic table to show all info

e.g. 

The table on the tooltip page looks like 

Section     | Value 

HR            | 10

Finance     | 14

Marketing | 12

etc

The tooltip kind of works, but i would like to autoamtically filter depending on what page you are on. 

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. 

At the moment, when you hover over the month, it shows everything from all sections. 

Can someone assist me in getting the tooltop to filter based on the page. 

I tried the 'Keep All Filters' toggle on the toolip page, but then shows blank tooltip on each section page. 

Thanks in advance

[Anonymous]

Hi @PPStar ,

Has the problem be solved?

Please consider to mark the reply as solution if it's helpful.

[NikhilChenna]

Hi @PPStar ,

For this you have to you selectedvalue function in you measure which is being used in the tooltip page calculation. 

Refer this link for more infor on selectedvalue, 

https://learn.microsoft.com/en-us/dax/best-practices/dax-selectedvalue

Regards,

Nikhil Chenna

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

[amitchandak]

@PPStar , the section of measure should filter based on the same filter you use on page.

Assume the filter is page name

calculate([Value measure], filter(Table, Table[Section] = selectedvalue(Page[Name]) )

[PPStar]

i dont understand this. 

what is value measure?. 

[NikhilChenna]

Hi @PPStar ,

Use this below measure,

Section     | Value 

HR            | 10

Finance     | 14

Marketing | 12

Measure = calculate(SUM([Value]), filter(Table, Table[Section] = selectedvalue(Page[Name]) )

Regards,

Nikhil Chenna

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

[PPStar]

OK, i got the first part, dont understnad the second part SelectedValue(Page[Name]))

The SelectedValue is looking for a column Name when i enter page its greys out, do i have to hardcode the page name?

apologies for the basic questions, im a newbie. 

[NikhilChenna]

Hi @PPStar ,

 Sorry do not use the last past. 

Only the keep you measure as SUM([Value],

And use the below link for adding to the report pages ,

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips?tabs=powerbi-desktop

https://databear.com/custom-tooltips-report-tooltip-pages-in-power-bi/

Regards,

Nikhil Chenna

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!