Forum Discussion
grouped line chart
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
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 !!