Visual Interactions?

[Spudduk]

Hi,

I have a report with  bar graph visuals that detect various levels of date aggregations, example WTD, PTD and YTD

I then want to build a set of visuals that will display the data over another date range based on the collumn selected from a chart. 

The commonality is the Site across all the visuals

So if I click on the Site for the WTD the Daily Graph will then display that site data for the past 4 weeks  in daily buckets, same with the PTD where it will display the weekly data.

When I use the Interactions it seems to be filtering by the date as well, so my 28 day visual is "in last 28 days = true" but selecting the WTD site applies a filter by the WTD so shows only 3 days, when I want to use the SITE only as the filter to show 28 days.

I know it soumds simple but I'm having a moment !!!

Andy

[v-kkf-msft · Accepted solution]

Hi @Spudduk ,

I am not sure if I understood your question correctly. What do you mean by showing only 3 days?

If you want to display the last 28 days of data when you select WTD, please try the following measure.

Measure = 
VAR _WTD =
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER (
            'Calendar',
            'Calendar'[Date]
                > TODAY () - 28
                && 'Calendar'[Date] <= TODAY ()
        )
    )
RETURN
    SWITCH ( SELECTEDVALUE ( Slicer[Site] ), "WTD", _WTD, SUM ( 'Table'[Value] ) )

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.