Matrix row selection driving wrong chart filter

[RE_AM]

I have a matrix table that shows properties and how much their total money owed is.  In the chart below, I show what the total owed is (over various stacked categories) for the last trailing 12 months.  The problem is when i want to filter the chart below by selecting a specific property from the matrix above, the chart goes from the default trailing 12 view to only showing data for the current month.  I'm wondering if it's because the measures i'm using in my matrix are meant to only show Total/0-30/30-60past due/60-90pastdue/etc for the current month (i.e. values for each of these categories as of Feb in this case).  what is odd to me, is if i reset the chart and the matrix, but use the slicer on the left hand side...everything works perfectly.  I suppose this is fine, but many users like to "click" in the data matrix to drive other visuals - so a fix would be helpful.

Measures...

Current owed Measure =

_CM Current Owed = CALCULATE (

    SUM ( 'Tenant AR'[Current Owed] ),

    DATESINPERIOD ('Tenant AR'[As of] , MAX ('Tenant AR'[As of]), -1, MONTH )

)

The 0-30/31-60/61-90/90+ are all the same style measure just with 'Tenant AR'[Current Owed]' swapped for 0-30/31-60/etc.

see visuals below...

STANDARD DEFAULT WHEN NOTHING SELECTED IN MATRIX:

ISSUE:  WHEN PROPERTY SELECTED IN MATRIX THE CHART GOES TO ONLY SHOWING CURRENT MONTH...

BUT NOTE WHEN I SELECT SAME PROPERTY FROM SLICER THE CHART WORKS AS WANTED...

[RE_AM]

table for property slicer is CON_PROP_ATTRIBUTES...which is also the same table that drives the first column in the data matrix.

[lbendlin]

Please explain its relationship with the CON_PROP_LIST_VW  table.

[RE_AM]

how do i just share the file as an attachment?

[lbendlin]

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

[RE_AM]

I'm afraid i'm still new to PowerBi and this went way over my head.  Below is the mapping

The Property Name comes from Con Prop Attributes and everything else comes from Tenant AR

[lbendlin]

which table feeds the slicer?

[lbendlin]

Behavior like that indicates that your data model is missing the dimension tables and all your slicers are fed from the same fact table. Refactor your data model and report.