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

Problem with a line graph

Hi, 
I'm working with a report of sales, but I have a problem with a line graph. I need to switch rows and columns but when I try to do it I got a message that says that a table can't have more than 2200 columns. Of course I won't show all my registers in the graph. I have another page with filters

 

asdsad.jpg

 

This is part of my table, and the top of the columns are months and years of the sales.

 

grafica bien.jpg

This is how I want to look my graph

 

 

 

And this is what I got

grafica mal.jpg

 

So what I need is to give a each product a line instead of giving a period of time a line.

 

Hope you can help me. 

Thanks

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-yulgu-msft Super Contributor
Super Contributor

Re: Problem with a line graph

Hi @abisaileon11,

 

In Query Editor mode, unpivot columns to format the table structure as below:

1.PNG2.PNG

 

Place [Year_Month] onto X-axis, and place [Product] into legend.

3.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
v-yulgu-msft Super Contributor
Super Contributor

Re: Problem with a line graph

Hi @abisaileon11,

 

In Query Editor mode, unpivot columns to format the table structure as below:

1.PNG2.PNG

 

Place [Year_Month] onto X-axis, and place [Product] into legend.

3.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
abisaileon11 Regular Visitor
Regular Visitor

Re: Problem with a line graph

Hi
Thank you so mucho for your reply, It has been very helpful.
Now I'm having another problem. When I unpivot the table the column of month/year doesn't respect the order

t.jpg

As you can see. 

And When I create the graph also It doesn't haver order in the axis

grad.jpg

You know how I can solve this?

Thank you for your help. 

 

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 123 members 1,674 guests