Filter X-axis without filtering Data

[Kurtle]

Hi Friends, 

I am currently working with an accounting model that contains 2 date tables. One for the accounting date and one for the activity date. I am trying to filter the data down based on the accounting date but displaying it on activity date. 

The green box is my activity date and the red is accounting. So far so good. 

Now when I filter my chart to be from Jan 1, 2020 onwards I am losing some costs. The measure I am using is simple Field Expenses = Calculate( Sum( 'Line Items'[Amount]), 'Line Items'[Major Account] = "999") 

Does anyone have any suggestions on some Dax conditions that I can use to avoid this from happening? 

Here is the data model:

Thank you in advance! 

[v-lili6-msft]

HI  @Kurtle 

What is "when I filter my chart to be from Jan 1, 2020 onwards I am losing some costs." ? 

maybe you could adjust the measure as below:

Field Expenses =
CALCULATE (
    SUM ( 'Line Items'[Amount] ),
    FILTER ( 'Line Items', 'Line Items'[Major Account] = "999" )
)

If not your case, please share your sample pbix file and your expected output.

Regards,

Lin

[Kurtle]

@v-lili6-msft Oops. I should have clarified that. When I filter my activity dates down to be from Jan 1, 2020, onwards so that my bar chart only shows those bars  I lose some costs because there are 2 date columns in me Line Items Table which is getting filtered out during that process.

[v-lili6-msft]

hi  @Kurtle 

You are using different column to filter and display data in the visual.

you filter the data down based on the accounting date but displaying it on activity date. 

This is a normal result, what your expected output? could you please share your sample pbix file and your expected output.

Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Regards,

Lin