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.
Having trouble figuring out how to compare mutiple years of cost data on one Jan-Dec line graph. I was thinking this configuration would get me what I am looking for....but it give me a cont. x-axis.
Can anyone help?
Solved! Go to Solution.
Try using the month name on the x Axis. Or you can also use the custom visual called 'Small Multiples Line Chart' which is even better in this case so you dont get a spaghetti chart
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Hi @warnera,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?
Regards,
Daniel He
Try using the month name on the x Axis. Or you can also use the custom visual called 'Small Multiples Line Chart' which is even better in this case so you dont get a spaghetti chart
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
can you clarify how you have the months formatted in your table? I followed a tutorial to make a dDate table and my Jan-Dec is formatted as text only. If I try to change the date type to date, I get an error. Thanks
Hi @warnera
the month is formatted as text. This is the Month column of the usual AdventureWorks Data Warehouse
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
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 |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |