Forum Discussion
bixby
5 years agoNew Member
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...
- 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_)Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.