Second line is not showin correctly

Q&A
,
1

Hi, i am trying to create simple Stacked bar combo chart, with two line. First line (red one one a picture) is shown correctly, but the second is shown only where there are data on month. When I swap them on the left column, the upper line is shown whole and lower one is broken.

I need to see both lines continuous.

Is this some kind of error or it is about some settings please?

image
image1452Ă—660 71.4 KB

2

Hello Vasek,

To create a continuous line in a Quick Sight stacked bar combo chart where both lines are shown completely, even when there’s no data for certain periods, you can try these solutions:

  1. Data Preparation:

  • Make sure you have data points for all time periods, even if the values are 0

  • You might need to fill in missing dates/months using calculated fields or data preparation

  1. Messure Settings:

  • Go to the Field Wells panel - Format data for the impacted measure (

  • For both line measures, check their settings by clicking on the field dropdown

  • Try to Set “Null value” treatment to “0”

image
image272Ă—626 9.1 KB

  1. Alternative Approach: If the above doesn’t work:

  • Create a calculated field with IFNULL or COALESCE to replace NULL values with 0

  • Use this calculated field instead of the original measure

Hope this gives some idea.

Cheers,

Deep

3

Hi thank you, but it does not work or i am not creating calculated field correctly.

But still can not understand that one line can be seen as a whole and the seccond one cannot.

4

Hi @Vasek ,
just to let you know that we are analyzing the issue!
We’ll let you know ASAP :slight_smile:

Andrea

5

QS problem 2
QS problem 21435Ă—351 67.3 KB

There is a same problem with line chart. There is even a setting for miising data (continious line), but it doesnt work either.

Thank you for analyzing this issue guys.

6

Hi @Vasek,

Hope this message finds you well! Do you have any other questions/concerns that pertain to this thread? If you do not and/or we do not receive a response within the next 3 business days, I’ll go ahead and archive this topic.

Thanks!

7

Hi, no other further questions. Just please let me know when you analyze the issue and if you figure out some solution.
Thank you.

8

Hi @andrepgn,

Hope everything is well! Just checking in to see if there has been any further progress made on analyzing this issue.

Thank you!

9

Hi! :waving_hand:
This usually happens when QuickSight breaks the line at missing data points. Try going to Format visual → Y-axis → Missing data and set it to Show as continuous line.

If that doesn’t help, use a calculated field like:

{
COALESCE([YourMeasure], 0)

}
to fill missing values. That should make the second line display correctly.

Hope so this will help you. If not you can tell me i will try to find some other possible fixes.

1 Like
10

Hi @Vasek

Did the @Ahmad-Talha suggested solution work or was the issue resolved? If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

11

Hi @Vasek

Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!