Line Graph - Count vs Weeks

[HenryJS]

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'

[Anonymous]

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

[HenryJS]

Hi @Anonymous 

Thanks

How do I get the two different job types to show up as two different lines?

[Anonymous]

Use the Drag the JobTyp to the Legend field

[HenryJS]

Thanks Lon

Last question - I want the x axis to have more intervals marked?

Cheers

[v-gizhi-msft]

Hi,

Please try to change X-axis type to 'Continuous':

Best Regards,

Giotto Zhi

[Anonymous]

You mean something like that?

https://docs.microsoft.com/de-de/power-bi/visuals/power-bi-line-chart