Creating Line chart with based on month provide and sales

[Anonymous]

Hi,

I want to create a line chart which display providers in Y axis, month in X axis and sales as line in a chart. Lines goes up and down depends on sales amount by months and providers. Is there any power bi chart that I can use like this. Appreciate for any help. Thanks in advance. 

[ibarrau]

Hi, please consider sending an image in paint of your idea because it doesn't make sense. If you have Y axis (values) and X axis defined, then you can't add another value for line because you have your dot where it's going to draw the visualization (X and Y point).

What you can do is creating a line chart with months as X axis, Sales as values (Y axis) and add the providers as legend so it will create a line for each provider. If there are too many providers add a slicer to check values.

Hope this helps,

Regards,

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

[Anonymous]

This is what was asked me to do. 

[ibarrau · Accepted solution]

I'm sorry but you can't do that. Power Bi will draw with X and Y axis dots. The providers in the picture are not dots, that doesn't make any sense. Does the other way I suggest is ok? (having X axis as months and values as sales, then provider as legend or in a slicer visualization)

Regards,