Forum Discussion

RIMMIMI's avatar
RIMMIMI
Frequent Visitor
5 years ago

Line Chart Visualization Error

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)],DATESINPERIO...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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

      • RIMMIMI's avatar
        RIMMIMI
        Frequent Visitor
        5 years ago

        hello,

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

        Thank you

        Rim