Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi all,
I have to series appended which I am displaying in the same line chart. I would like to have the data for one of the series to display as solid lines and the other series to display as dotted lines. Is this possible? When I change the shape to dotted lines it seems to change both series.
This is what I am trying to achieve:
Thanks,
Beatriz
Solved! Go to Solution.
Hi @tringuyenminh92,
I am able to follow the approach without using a measure, just selecting each series. I only have 10 series for now:
I have another solution for this problem! I create another column with the same values of the first one (the one you want to show) like that (Note the "2500" value on formula is random, just so we do not overwrite the original value):
after this I go to the line chart and put all two Values and rename one of these values to " " (just an space):
So now I have this:
After that, I go to "Format>Data Colors" and select for " " measure the same color of the background. After that you go to "Format>shapes>Customize series" select the " " measure and select Line style = Dashed. When you apply these filters you can see an override on the line plot after "TODAY()":
Best regards,
Hi @bmayz,
So far you could not customize x-axis like your expectation, but you could separate your measures to 2 parts (one measure for solid line and another for doted line). Adjust them to same color and ensure they have intersection point.
Hi @tringuyenminh92,
Thanks so much for your response. I'm new to Power BI, so, not sure how to set the measures for dotted and solid lines. I know how to create the measures but not how to customize the line style for them.
Could you please share the steps for this?
Thanks,
Beatriz
Hi @bmayz,
Please ensure you are using the newest version of PBI Desktop. In the Format option -> Shape -> choose measure you want to adjust
Create 2 calculated measure:
(To ensure there is no confusing for users, you could trick mesure name with one space)
This works great, thanks!
Hi @bmayz,
Firstly choose your chart -> in Format area -> choose Shapes -> Choose measure you want to customize
Hope you got it now.
Thanks @tringuyenminh92,
I was actually referring to this pane:
Thanks for posting your solution, whoever, I'm not sure it will work for me as I need to display the products in the legend rather than the measure names. I have multiple lines, each of them will have half of them solid and the other half should be dotted.
Hi @bmayz,
It's just workaround. How many items you have? if there are a few items, you could follow this approach.
Hi @tringuyenminh92,
I am able to follow the approach without using a measure, just selecting each series. I only have 10 series for now:
Hi @bmayz,
I know this is old, but could you explain this solution to me? I am only able to get this to work by following tringuyenminh92's method and creating separate measures for each line rather than doing a legend. Were you somehow able to do it using one measure and a legend? If so, how? Thanks.
Hey there,
I know this has been a while but were you able to figure it out?
I wasn't able to replicate without creating separate measures for each line and it does not really work if I have a legend along with it with a slicer.
Thanks
Hi @bmayz,
Great to hear the problem got resolved! Could you accept your reply above as solution to close this thread(it will help others who has similar issue easily find the answer)?
Regards
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
116 | |
103 | |
87 | |
35 | |
35 |
User | Count |
---|---|
152 | |
99 | |
83 | |
63 | |
54 |