Forum Discussion
Tooltips - prevent one filter
Hi Everyone, I have a report page (Report page 1) with sales in the week for each store and linked to this report page I have a tooltip which is showing a chart for sales over the last 8 weeks. I...
Hi,
I might be being a bit silly, but I don't think that solves my problem. I can get the chart to filter correctly but I want it to keep the date filter but use the store filter when it is a tooltip.
PowerBIWhat
Try use allselected() instead of all(),Measure = CALCULATE(sum(Table1 [Sales]),
FILTER(ALLSELECTED(Table 1 [shift_period]), Table 1 [shift_period] > -8))Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.Hi,
This is filtering it when i view the page, but not when I use it as a tooltip?