To show dots instead of line in line chart

[atul9063]

Hi, 

I have to display below data in dots instead of line.

 

I want to show above data in below format

in Line Chart visualization, I have change X axis Type to Categorical ,even then its not showing in dots.

[MFelix]

Hi @atul9063,

This option is not related with the type of axis but with the line options.

Go to the format options of the line chart:

• Shapes
• Stroke With = 0
• Show Marker On

This wil give only the dots on the chart.

Regards,

MFelix

[atul9063]

@MFelixI m not able to see Show Marker option in Line Chart

[MFelix]

Hi @atul9063,

What version of PBI you have? And the setup you present on the image is the one for your chart or do you have any additional information on the chart like measures, hierarchy, ...?

To check it try to create a line chart from scratch and then check if the option show marker appears.

Regards,

MFelix

[atul9063]

@MFelixI m using November version.I have mentioned sample data in post .Please check

[MFelix · Accepted solution]

Hi @atul9063,

Looking at you data you should be abble to place the fields on the line chart:

• Axis - Date
• Legend - Legend
• Values - Value

Then go to Shapes and turn on the Customize series and edit the markers and lines.

Check the PBIX file attach.

Regards,

MFelix

[atul9063]

Thanks for solution!!!

[atul9063]

I will try on my dataset and let you know

[PattemManohar]

@atul9063 Please try with "Scatter Chart" visual

[atul9063]

@PattemManoharI have to show line and dots both in same chart.Is this possible in scatter or line chart?

[PattemManohar]

@atul9063 Oh ok !! Could you please explain what data you want to as line and dots. 

Sample data in copiable format to replicate the same (if the above sample data is not enough to replicate your issue)

[atul9063]

@PattemManohar  Below is sample data.I want to display Moto in dots and Nokia in line in same visual.Moto is monthly data and Nokia is daily data.

Date	Legend	Value
3/5/2018	Moto	45
4/5/2018	Moto	11
5/5/2018	Moto	12
6/5/2018	Moto	16
3/5/2018	Nokia	12
3/6/2018	Nokia	13
3/7/2018	Nokia	14
3/8/2018	Nokia	15
3/9/2018	Nokia	16
3/10/2018	Nokia	17
3/11/2018	Nokia	18
3/12/2018	Nokia	19
3/13/2018	Nokia	20