Stacked Column Chart - including data from table with two different date columns

[Anonymous]

Hello,

I have a Power BI report with 3 maine tables: PA, NAV and  Date. The date table is used to filter by year in my report, therefore, all the other tables are connected to it through their Date column.

However, the PA report has a second date column called "date updated". 

What I try is to build a stacked column chart where on the Shared axis I have the date and in the column axis I have two values: The "Total Amount" from the NAV table and on top of it, the "Upcoming Amount" from the PA table. The trick is that since my PA dataset is a panel data where every month new data is added,  I would like the Upcoming amount to be split by "date updated".  

So what I would like si to have the two figures below in one single graph, on top of each other. Of crouse, the PA table only has data from August, September and October and that's ok. I tried this method: https://exceleratorbi.com.au/multiple-relationships-between-tables-in-dax/, but a measure will not work since I use some additional filters on my page.

Thanks for trying to help. 

[MFelix · Accepted solution]

Hi @Anonymous ,

The calculation here needs to be done with the inactive relationship has is referred on the blog you shared.

If you create an inactive relationship between the Date table and the PA date updated using the USERELATIONSHIP you can get the information on that column and not on  the active relationship.

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.