Visual Level Filters

Hi Jehannum9,

In your scenario, if value of "Posting Period" in page level filter is "003", it will be "001, 002, 003" in visual level. This is a paradox. We want the whole page shows up the value of 003, while one visual shows up "001, 002, 003". That means the page level filter doesn't work properly. 

There could be a workaround. We can integrate the visual level filter into measures. Something like this:

Measure =
IF (
    HASONEVALUE ( 'table'[Posting Period] ),
    CALCULATE (
        [formula],
        FILTER (
            ALL ( 'table' ),
            'table'[Posting Period] <= VALUES ( 'table'[Posting Period] )
        )
    ),
    [formula]
)

Best Regards!

Dale

I see your workaround and it got me to thinking.  If I set a page level filter to all of the posting periods needed for a YTD calculation, then I could set the Single Period KPI with a visual level filter to top 1.  

i.e.

So with a Page level Filter set like this:

My YTD Metrics would remain unfiltered on Posting Period.

My Single Period Metric would be set as

Thank you Dale for you quick response and helping me to see the problem from a different viewpoint.

Tim