grouped line chart

[kenana007]

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?

[v-sdhruv]

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 You

[v-sdhruv]

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 You

[v-sdhruv]

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 You

[danextian · Accepted solution]

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

[johnbasha33]

@kenana007 

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" like 2023-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 !!