Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 from 2015-2017. Instead of a line, it would make much more sense to have a data point in 2010 and have the line from 2015-2017. Bascially, I need line breaks where I do not have data points.
I did not find such option in the line chart.
Solved! Go to Solution.
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.
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!
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.
Hi @weilai0521 ,
You can make some settings in Format pane like picture below .
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I changed the line to dotted line. It is not helping.
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.
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!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |