Forum Discussion

kenana007's avatar
kenana007
New Member
1 year ago
Solved

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 w...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    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

     

danextian's avatar
danextian
Super User
1 year ago

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