Forum Discussion

weilai0521's avatar
weilai0521
Frequent Visitor
7 years ago
Solved

Line break in line chart

  Hi, I have the following chart. For several lines, I do not have data points for certain years. For example, for the blue line, I only have the 2010 data point and then I have the data points fro...
Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi weilai0521 ,

     

    Follow the steps below, then it will return the result you desired.

     

    1.Set the X axis type to "Categorical" instead of "Continuous", which will make the "Show marker" button available.

     

     

     

     

     

     

     

     

     

     

     

    2.Turn on the "Show marker" button .Select the Marker shape you prefer from the drop down. For further customization => Turn On => Customize Series or other  Customize shapes, size, color and so on.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards,

    Amy

     

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

  • weilai0521's avatar
    weilai0521
    7 years ago

    I really appreciate the help. 

     

    I tried the categorical option but it gives me a graph like this. The year order mess up. Is there a solution for that? I tried to create a year_order variable and sort the year by year_order, which does not solve the problem. 

     

    Thanks!

     

  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi weilai0521 ,

     

    When I create the Year column from formula Year = YEAR(Sales[DateKey]), I can reproduce your scenario. I worked around this issue following steps below.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    While if you get the Year column from a date field, it won't have the issue.

     

     

     

     

     

    Best Regards,

    Amy

     

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

sylvans's avatar
sylvans
Advocate I
1 year ago

The solution here did not work for me. Rather, a simple DAX is able to resolve these broken lines but if there's a built-in formatting / solution, please let me know.

 

Count_of_Codes = 
    VAR var01_Count_of_Codes = COUNT('Dummy_FactTbl'[Dummy Code])
RETURN
    IF(var01_Count_of_Codes = 0,
        0,
        var01_Count_of_Codes
    )