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.
I'm running into an issue trying to create a line chart. This is what I'm trying to do (excel visual):
I've imported a table like this, with other columns such as year, project ID, title, etc. And like the table above, it has columns for January, February, March, etc. Note: There are multiple rows listing out all the projects, and each project ID has 2 rows with type equal to 'planned' or 'actual'. I'm filtering my reports by project ID.
When trying to create a line chart comparing planned vs actual, I get this:
How can I fix this? I feel like I have tried everything (aside from restructuring all the data I'm importing).
Solved! Go to Solution.
Hi @Starseed ,
First, select the type column in the query editor and unpivot other columns.
Incorrect month sorting may appear in the chart. You can create a condition column to sort.
You can get this result.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Starseed ,
First, select the type column in the query editor and unpivot other columns.
Incorrect month sorting may appear in the chart. You can create a condition column to sort.
You can get this result.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Great! Got it to work. Thanks for your help.
Reference for others looking to see how I solved the problem with the solution above:
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.