Forum Discussion
Stop Page Level Filter From Applying to One Visual
- 8 years ago
we're not understanding;
my suggestion is to establish the value at the table level. this will rerun at each data refresh.
for instance if you create a new calculated table - that is the Sum of X. that stand alone figure/value, put into a visual, will not be affected by filtering of other visuals on the same page.
vcastello Since this is not a one time report but one that I will be currently updating.
Every time I publish the report the page level filter is going to be to a different date so to change every visual every time is going to be time consuming.
Hi skylarw
If you have a calendar table you can
1.- Create a new calculated column called IsToday ...
IsToday = IF([Date] = TODAY(), 1, 0)
Being [Date] the date column in your calendar table
2.- Filter all the Today's visuals by IsToday and set it to 1
Should that work?
Vicente