cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
szervos Frequent Visitor
Frequent Visitor

X-axis shows more values than those filtered

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.

tempsnip.png

 

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

 

Thank you in advance!

1 REPLY 1
v-cherch-msft Super Contributor
Super Contributor

Re: X-axis shows more values than those filtered

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,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 401 members 4,044 guests
Please welcome our newest community members: