Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
This is part of my table, and the top of the columns are months and years of the sales.
This is how I want to look my graph
And this is what I got
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
Solved! Go to Solution.
Hi @Anonymous,
In Query Editor mode, unpivot columns to format the table structure as below:
Place [Year_Month] onto X-axis, and place [Product] into legend.
Best regards,
Yuliana Gu
Hi @Anonymous,
In Query Editor mode, unpivot columns to format the table structure as below:
Place [Year_Month] onto X-axis, and place [Product] into legend.
Best regards,
Yuliana Gu
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
As you can see.
And When I create the graph also It doesn't haver order in the axis
You know how I can solve this?
Thank you for your help.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |