Line Chart Visualization Error

[RIMMIMI]

Hello ,

Im struggling with a line chart report , my target is to display the result between march 2020 and march 2021 , I used this request :

LA = CALCULATE([ID INCIDENT(No Blank)],DATESINPERIOD(ExportSM9[ConvertDATEOUVE],DATE(2020,3,1),13,MONTH))

But I still have the results between Jan2020 and December 2021

My result is :

Thnak you

[Anonymous]

Hi @RIMMIMI ,

Not very clear. Could you please share some sample data and the expected result to have a clear understanding of your question? I can do some tests for you. You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.

Please try to create the following measure and drag it to the filter of  line chart visual, then select "=1".

Measure  = IF(MAX(ExportSM9[ConvertDATEOUVE]) in DATESINPERIOD(ExportSM9[ConvertDATEOUVE],DATE(2020,3,1),13,MONTH),1,0)

Hope that's what you were looking for.

Best Regards,

Yuna

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[RIMMIMI]

Hello

Thank you for your reply , unfortunately id does'nt work this request , the link to my pbix is here an thank you:https://drive.google.com/drive/folders/1xDDKHrsqzYuKdyGsktOwYB_ixSpSSFjq

Thank you

Rim

[Anonymous]

Hi @RIMMIMI ,

I can't open it. It seems that I need a permission. Could you share your sample file that I can download it directly?

Best Regards,

Yuna

[Syndicate_Admin]

Hello

Can you try again? I can't insert it here directly, I changed the permissions

Thank you

owe

[Syndicate_Admin]

Hello

Can you try again? I can't insert it here directly, I changed the permissions

Thank you

owe

[Syndicate_Admin]

Hello

Can you try again? I can't insert it here directly, I changed the permissions

Thank you

owe

[Syndicate_Admin]

Hello

Can you try again? I can't insert it here directly, I changed the permissions

Thank you

owe

[Syndicate_Admin]

Hello

Can you try again? I can't insert it here directly, I changed the permissions

Thank you

owe

[Syndicate_Admin]

Hello

Can you try again? I can't insert it here directly, I changed the permissions

Thank you

owe

[Syndicate_Admin]

Hello

Can you try again? I can't insert it here directly, I changed the permissions

Thank you

owe

[Syndicate_Admin]

Hello

Can you try again? I can't insert it here directly, I changed the permissions

Thank you

owe

[Syndicate_Admin]

Hello

Can you try again? I can't insert it here directly, I changed the permissions

Thank you

owe

[Syndicate_Admin]

Hello

Can you try again? I can't insert it here directly, I changed the permissions

Thank you

owe

[Syndicate_Admin]

Hello

Can you try again? I can't insert it here directly, I changed the permissions

Thank you

owe

[Syndicate_Admin]

Hello

Can you try again? I can't insert it here directly, I changed the permissions

Thank you

owe

[Syndicate_Admin]

Hello

Can you try again? I can't insert it here directly, I changed the permissions

Thank you

owe

[Syndicate_Admin]

Hello

Can you try again? I can't insert it here directly, I changed the permissions

Thank you

owe

[Syndicate_Admin]

Hello

Can you try again? I can't insert it here directly, I changed the permissions

Thank you

owe

[Syndicate_Admin]

Hello

Can you try again? I can't insert it here directly, I changed the permissions

Thank you

owe

[Syndicate_Admin]

Hello

Can you try again? I can't insert it here directly, I changed the permissions

Thank you

owe