Forum Discussion

Helper V

3 years ago

Filters on Tooltips

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...

Super User

3 years ago

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]) )

Helper V

3 years ago

i dont understand this.

what is value measure?.

NikhilChenna
Skilled Sharer
3 years ago
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
  Helper V
  3 years ago
  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
    Skilled Sharer
    3 years ago
    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!

Related content