Forum Discussion
Line Graph - Count vs Weeks
Hi all,
How can I do a line graph with two lines
One line for 'Contract' job type and one line for 'Permanent' job type.
Against an axis of weeks of the 'Created Date'
6 Replies
Hi Henry,
has your Datamodel one or more tables?
If the [JobType] and the [CreatedDate] are in the same Table, insert a new Item as Week unsing
Week = WEEKNUM([CreateDate];2) -> 2 for week starts on Monday.
Then i would also insert a Dax Count four your entries, which become the Datapart for your Line Graph.
If the data are in seperate tables, do the same with the Week, and connect the Data via Relations.
Cheers
Lon
Hi Anonymous
Thanks
How do I get the two different job types to show up as two different lines?
