Forum Discussion

Stofi's avatar
Stofi
Regular Visitor
2 years ago

Line and Stacked Column Chart/ problem with line display value

Hi everyone! My problem lies in the Line and Stacked Column Chart. I have imported 2 sheets one with dates/times that I want (Opened - 70) and other one with all dates/times (Total - 1071). Line should show how much was per month instead it is a straight line. Since "Total" is set as date/time why does it show it as total value 1071 and not each number per month?

If I want to create a relationship between these two, it shows up like this. Mind you, that "line" should display over 1000 results. 

Does anyone know how to deal with this? Any help would be appriciated!

Need Help

1 Reply

  • Bijen_Shah's avatar
    Bijen_Shah
    Regular Visitor
    2 years ago

    The issue is that these two sheets (tables) have different row context 

    You need a calendar table connecting both these tables on a 1 to Many relation
    Then instead of using dates from one of the either tables you use the dates from calendar table and it will filter both tables and give row context for appropriate results.
    use = Calendar() DAX function to instantly create a Calendar table

    Did I answer your question? Kindly mark my post as a solution!
    Appreciate your Kudos! Happy to Help!