Forum Discussion

bixby's avatar
bixby
New Member
5 years ago
Solved

Line Chart Assistance

Hi all,   I have a table TICKETS that has date columns [ created ] , [ assigned ] , [ resolved ]   I want to display a line chart of all the tickets with those three separate lines as they all ha...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Hi bixby ,

     

    Maybe I understand what you mean,you need to create an unrelated calendar table as an x-axis or slicer.

    Then create 4 measures like this:

    Measure = 
var count_ = CALCULATE(COUNT('Table (3)'[ticket_id]),FILTER('Table (3)','Table (3)'[created_date].[Date]=MAX('Table'[Date])))
return IF(ISBLANK(count_),0,count_)

    Sample .pbix

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

gpiero's avatar
gpiero
Skilled Sharer
5 years ago

bixby 

Hi, 

could you share some sample data or an expected result you are looking for?

Regards

  • bixby's avatar
    bixby
    New Member
    5 years ago

    Desired outcome:

    Apply ONE date slicer to multiple date values in a line chart (chart shows number of tickets by date - lines represent "created", "assigned", "resolved", "unassigned"):

     

    Example line chart

     

    Sample Data:

    ticket_idcreated_dateassigned_dateresolved_dateunassigned_date
    17/29/2020 8:59:34PM7/29/2020 9:19:34PM7/30/2020 12:59:34PM 
    27/29/2020 9:59:34PM  7/29/2020
    37/29/2020 10:59:34PM7/29/2020 9:25:34PM8/3/2020 6:59:34PM 

     

    • V-lianl-msft's avatar
      V-lianl-msft
      Community Support
      5 years ago

      Hi bixby ,

       

      Maybe I understand what you mean,you need to create an unrelated calendar table as an x-axis or slicer.

      Then create 4 measures like this:

      Measure = 
var count_ = CALCULATE(COUNT('Table (3)'[ticket_id]),FILTER('Table (3)','Table (3)'[created_date].[Date]=MAX('Table'[Date])))
return IF(ISBLANK(count_),0,count_)

      Sample .pbix

       

      Best Regards,
      Liang
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.