Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Unable to draw multiple lines on line chart correctly

Alright, it's been a month now and I am exausted in looking for a solution online. I believe I have tried all the known solutions. Let me describe the problem below   I have a simple table  ...
Reports
e0318476's avatar
e0318476
Icon for Helper I rankHelper I
4 years ago

Hi MFelix,

 

Thank you for your reply. I am working on a file and I am having issues to solve it after viewing your PBIX. Would really appreciate if you could help me with this dataset. 

 

With the sample set above, I would like to acheive this result:

Thank you!

    • e0318476's avatar
      e0318476
      Icon for Helper I rankHelper I
      4 years ago

      Hi Miguel,

      I am facing issues with drilling down my data. For example, I want to look at who have registered for a course the month of July. When I click on the graph, it does not give a drill down of the names. 

       

      Please help if possible. Thanks!

       

      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper User
        4 years ago

        Hi e0318476 ,

         

        The question here is context since you are not using the full name that is not part of the measures you are using for the line chart you don't get the result you need.

         

        You need to add the data context to your calculation. Add the following measure:

         

        Count rows =
COUNTROWS (
    FILTER (
        SUMMARIZE (
            'Table',
            'Table'[Full Name],
            'Table'[Completion Date],
            'Table'[Registration Date]
        ),
        'Table'[Completion Date]
            IN VALUES ( 'calendar'[Date] )
                || 'calendar'[Completion] IN VALUES ( 'calendar'[Date] )
    )
)

        Top char the same has yours, bottom chart with trhe measure above.