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)],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

 

Need Help

54 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    RIMMIMI , does this measure uses +0 or handle is blank

    [ID INCIDENT(No Blank)]

     

     

    refer, +0 in the first var can give all dates. So I handled that remove dates again

     

    0 between range
    Measure = var _1= SUM(Opportunity[Opportunity count]) +0
    var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
    var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
    return
    CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))

    • RIMMIMI's avatar
      RIMMIMI
      Frequent Visitor
      5 years ago

      Hello ,

       

      Thank you , I dont know how to send you my pbix tell me how plz 

    • RIMMIMI's avatar
      RIMMIMI
      Frequent Visitor
      5 years ago

      thank you for your reply , but it didn't work , should I create a unique DAX or create the VARs and make the Calculate Fonction alone ? thank you

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi, RIMMIMI 

    If it is OK with you, please share your sample pbix file, then I can try to have a look and come up with a desirable solution. 

    Thank you.

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster.

    • RIMMIMI's avatar
      RIMMIMI
      Frequent Visitor
      5 years ago

      Hello

      I shared with you but It seems that you didn't see it thank you

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    HI RIMMIMI 

     

    It looks like either your DAX query doing zero handling because of measure you have created or your dataset having entry for the same. 

     

    In new page just drag this measure in table visual with all required column and check if data is coming till december 2021 or not . If it is coming with 0 value then measure need to be corrected. 

     

    Thanks

    • RIMMIMI's avatar
      RIMMIMI
      Frequent Visitor
      5 years ago

      Hello ,

       

      I had a matrix before transforming it to a chart line , indeed the values after march are 0, because my data stop at march 2021, I dont understand why it continues until december 2021 

  • 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.