Need to show continues days in X-axis Line chart though if there are any missing days

[Anonymous]

Hi Excepts , I need urgent help . I  have day_num column in below xl but few day_num's are missing though i want to show missing days too in Line chart x-axis. (don't want to use "Continuous" type)

If you see, the above for "Amazon" 16th day is missing i understand that , since there is no 16th Day_num for amazon , the Blue line cut off at 15 and starated at 17.. but the ask is , we have to show missing day's also ..for ex: here we have to show 16 day also..(i.e what ever the missing day's are there , we have to show with some 0 data for that particulart missing day )..any help is appriciated ?

[shafiz_p · Accepted solution]

Hi @Anonymous  Basically, if value in a perticular day is missing, line chart will cutofs there , unless you return 0 for that row. Try this example:

Missing values for day:

If fit line chart, it will show cutoffs:

Try this similar pattern measure:

Measure = IF(
    SUM('Table'[Value]) = 0,
    0,
    SUM('Table'[Value])
)

Problem solved:

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz

[uzuntasgokberk · Accepted solution]

Hello @Anonymous ,

Create Dim_Date table that includes MIN(date) and MAX(Date) or spesific year. Depending on your preference and make relationship with you table 1 to many. Finally, create the following measure:
"
test=
IF(ISBLANK([Sales]),0,[Sales])
"
Finally that will be X-axis is DimDate[Day] Y-Axis is the measure.

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |

[Ashish_Mathur]

Hi,

Assuming the day number on the X-axis is coming from the Calendar table, write this measure

Measure = coalesce([your measure],0)

Hope this helps.

[Anonymous · Accepted solution]

Hi @Anonymous ,

Based on the testing, creating the new table.

Table = GENERATESERIES(MIN(tes[DayNum]), MAX(tes[DayNum]),1)

Then, creating the new relationship between new table and tes table.

Creating the new measure to calculate the number.

Measure = 
var _reslut = CALCULATE(SUM('tes'[CPI]))
RETURN
_reslut + 0

Drag the new table column to the X-axis and drag the measure to the Y-axis.

Best Regards,

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

[uzuntasgokberk · Accepted solution]

Hello @Anonymous ,

Create Dim_Date table that includes MIN(date) and MAX(Date) or spesific year. Depending on your preference and make relationship with you table 1 to many. Finally, create the following measure:
"
test=
IF(ISBLANK([Sales]),0,[Sales])
"
Finally that will be X-axis is DimDate[Day] Y-Axis is the measure.

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |

[shafiz_p · Accepted solution]

Hi @Anonymous  Basically, if value in a perticular day is missing, line chart will cutofs there , unless you return 0 for that row. Try this example:

Missing values for day:

If fit line chart, it will show cutoffs:

Try this similar pattern measure:

Measure = IF(
    SUM('Table'[Value]) = 0,
    0,
    SUM('Table'[Value])
)

Problem solved:

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz