2 Different Visuals on the Same Report but differing time frames on the X - Axis.

[Spudduk]

I have a report where the top left  visual is based on a filter called Periods -1, so it always selects our last period by site. 

The bottom line chart is based on the filter where this is in current fiscal year = True..  So I get the full YTD.

When I click on the top left to select a site the bottom visual then only shows the filter "periods from today -1 "

When editing interactions I only have Filter or No Filter Option...

Is what I am trying possible or do have to use a slicer, I have been trying to keep the reports clean rather than having to change stuff on a slicer...

Cheers#

Andy

[Spudduk]

Thanks , but I have used the edit interactions and it is that I cannot get working, every time I click on the site bar in the top left , it acting as if it also sending across the "Periods from Today = -1" filter to the bottom filter. When all I want is the "SITE" filter and leave the date range as Year To Date...   Attached are the visual filters for the tope left and bottom visual....

[v-zhouwen-msft · Accepted solution]

Hi @Kaviraj11 , @farmdev ,thank you for your quick replies, I'll add more.

Hi @Spudduk ,

Regarding your question, create measures to populate the visual objects at your bottom.

The Table data is shown below:

1.Suppose the only filter I need to pass is the field 'Type'

2.Creating DAX Expressions with ALL Functions(Removed the filtering effect of the field 'Date')

ALL function (DAX) - DAX | Microsoft Learn

Measure = CALCULATE(SUM('Table'[Amount]),ALL('Table'[Date]))

 3.Final output

[farmdev]

Quick suggestion:

When editing interactions, do you have the bar graph selected before changing the other interaction?

When I first started using the interaction editor sometimes the wrong visual was highlighted.

[Kaviraj11]

Hi, are you trying to keep the line chart as it is even user interact with other visuals? If Yes, then using 'Edit Interaction', you can disable th interation to the other visuals.

Let me know if it's not clear

Change how visuals interact in a report - Power BI | Microsoft Learn