cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bmayz
Regular Visitor

Line Chart - Is it possible to have half of the chart as solid lines and the other half as dotted?

 

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:

 

Wireframe.PNG

 

Thanks,

Beatriz

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
bmayz
Regular Visitor

Re: Line Chart - Is it possible to have half of the chart as solid lines and the other half as dotte

Hi @tringuyenminh92,

 

I am able to follow the approach without using a measure, just selecting each series. I only have 10 series for now:

Capture2.PNG

View solution in original post

11 REPLIES 11
tringuyenminh92 Memorable Member
Memorable Member

Re: Line Chart - Is it possible to have half of the chart as solid lines and the other half as dotte

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.

 

bmayz
Regular Visitor

Re: Line Chart - Is it possible to have half of the chart as solid lines and the other half as dotte

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

tringuyenminh92 Memorable Member
Memorable Member

Re: Line Chart - Is it possible to have half of the chart as solid lines and the other half as dotte

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:

 

m.PNGrename measure with one spacem2.PNG

 

(To ensure there is no confusing for users, you could trick mesure name with one space)

 

1.PNG

2.PNG

 

 

bmayz
Regular Visitor

Re: Line Chart - Is it possible to have half of the chart as solid lines and the other half as dotte

Hi @tringuyenminh92,

 

Could you please share a screenshot of your Fields pane?

 

Thanks!

tringuyenminh92 Memorable Member
Memorable Member

Re: Line Chart - Is it possible to have half of the chart as solid lines and the other half as dotte

Hi @bmayz,

 

Firstly choose your chart -> in Format area -> choose Shapes -> Choose measure you want to customize

1.PNG

 

Hope you got it now.

bmayz
Regular Visitor

Re: Line Chart - Is it possible to have half of the chart as solid lines and the other half as dotte

Thanks @tringuyenminh92,

 

I was actually referring to this pane:

Capture.PNG

 

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.

 

tringuyenminh92 Memorable Member
Memorable Member

Re: Line Chart - Is it possible to have half of the chart as solid lines and the other half as dotte

Hi @bmayz,

 

It's just workaround. How many items you have? if there are a few items, you could follow this approach.Smiley Very Happy

Highlighted
bmayz
Regular Visitor

Re: Line Chart - Is it possible to have half of the chart as solid lines and the other half as dotte

Hi @tringuyenminh92,

 

I am able to follow the approach without using a measure, just selecting each series. I only have 10 series for now:

Capture2.PNG

View solution in original post

Microsoft
Microsoft

Re: Line Chart - Is it possible to have half of the chart as solid lines and the other half as dotte

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)? Smiley Happy

 

Regards

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors