Line Chart not skipping dates and fixing error bar

[eliasayyy]

hello everyone i have a calendar table , datatable, 2 disconnected date tables to choose from month vs month

my calendar table is a list from january 1 2023 to today()  my datatable has no data in some dates for example my datatable jumps from february 14 to march 14 , in 1 month i have no records

when i put the calendar table as x-axis and sum of values from datatable in y-axis , my line chart skips from feb 14 to march 14 and isnt continuous ina way

i am trying to make this

as you see i selected may and march since may has data from may 1 to may 31 , the line works and error bars work

but in march it skips from feb 19 to march 14 

and you can see that i dont have my second error bar because there is no march 1 

how to fix my issue here is full chart

[Anonymous]

Hi @eliasayyy ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[eliasayyy]

hello thank you but i was able to solve iton my own

[Anonymous]

HI @eliasayyy,

Ok, I'm glad to hear you find the solutions.
BTW, did you mind sharing it here? They may help others who faced the similar scenarios.

Regards,

Xiaoxin Sheng

[eliasayyy · Accepted solution]

yea sure , since i have a field paramter of measures , i had to create a switch measure for my measures based on the order of the field paramter

Switch Measure = 
SWITCH(
SELECTEDVALUE('Parameter'[Order]),
0,[Measure 1],
....
)

after that i made another measure called switch measure no blanks

SWITCH Measuer No Blanks = 
IF(ISBLANK(Switch Measure]),0,[Switch Measure])

now i forced my line chart to take into consideration the 0s

now for my error bars and line above i just replaced the measure used in the formual to the [switch Measure No Blanks]