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 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.