Forum Discussion
Solved
Custom Filter for Tooltip Hovering
Hi, I have a column chart that displays spending for a set of work weeks. I'm trying to create a tool tip that creates a waterfall chart for the main changes in spending by category between the week...
You would create a measure like:
Measure = VAR __week = MAX('Table'[Week]) - 1 VAR __table = FILTER(ALL('Table'),[Week]=__week) RETURN SUMX(__table,[Column])Something along those lines, tough to say without sample data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
You would create a measure like:
Measure =
VAR __week = MAX('Table'[Week]) - 1
VAR __table = FILTER(ALL('Table'),[Week]=__week)
RETURN
SUMX(__table,[Column])
Something along those lines, tough to say without sample data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hi Greg_Deckler ,
Once you have created the measure where do you put this? On the tooltip or visual?
Thanks,
