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

[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

[Anonymous]

Hi @RIMMIMI ,

Could you share the link to me again? I'm still be denied.

Best Regards,

Yuna

[Syndicate_Admin]

Hello

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

Thank you

Should

[RIMMIMI]

hello,

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

Thank you

Rim

[Anonymous]

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]

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 

[Jihwan_Kim]

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]

Hello

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

[amitchandak]

@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]

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

[RIMMIMI]

Hello ,

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