X-axis shows more values than those filtered

[szervos]

Hi,

I have two measurements for counting actual and potential patients on treatment.

On Treatment (Actual) = 
CALCULATE(
    COUNT(Patients[Patients]);
    FILTER(ALLSELECTED(Patients[PSP Duration Month]); Patients[PSP Duration Month] >=MAX(Patients[PSP Duration Month]))
)

On Treatment (Potential) = 
CALCULATE(
    COUNTA(Patients[Patients]);
    FILTER(ALLSELECTED(Patients);Patients[Current Month in PSP] >= MAX(Patients[PSP Duration Month]))
)

and in the x-axis I have added the PSP Duration Month which can be from 0 to 24.

When I filter the data (e.g. by filtering the year 2019) the range for PSP Duration Month is limited from 0 to 6, but this is not happening in the graph. Please check the screenshot.

Any ideas what is going on and the graph is kept displaying x-axis after 6?

Thank you in advance!

[v-cherch-msft]

Hi @szervos 

You may try to add IF condition to filter the two measures < 6(Max value of [Current Month in PSP] column).If you need further help,please share the .pbix file.You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

Regards,