Forum Discussion
grouped line chart
I assume the solution is simple but I can't seem to find it.
I have three sets of data and I want to have a diagram with the revenue per month and the three lines per year next to each other. It's working with two years but as soon as I add the third year and revenue it shows the total amount of that year instead of the amount per month.
What should I change?
Hi kenana007
How is the 2024 measure connected to the Year-Month dimension in your chart? It’s likely coming from an unrelated table, which is why you’re seeing a total instead of it being broken down by month. You might want to look into using a separate Dates table to bridge different fact tables — it helps keep everything properly connected and slicers working as expected
5 Replies
Make sure your X-axis is a combination of both Month and Year, not just Month.
Options:
-
Option 1:
Create a field that is "Year-Month" like2023-Jan,2024-Jan, etc. — and plot based on that. -
Option 2:
Use a hierarchy: "Year" > "Month" and expand it correctly on the axis. -
Option 3:
If you're using a line chart, set the Legend to "Year" and the Axis to "Month Number" (1, 2, 3... 12), not month name, so that each year draws its own line across the months.Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
-
Hi kenana007
How is the 2024 measure connected to the Year-Month dimension in your chart? It’s likely coming from an unrelated table, which is why you’re seeing a total instead of it being broken down by month. You might want to look into using a separate Dates table to bridge different fact tables — it helps keep everything properly connected and slicers working as expected
Hi @kenana007 ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank YouHi @kenana007 ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You
