LINE CHART

[Anonymous]

Hello everyone,
i should create a chart with the one below.
I have the month, year and number of jobs for year and month field. I use direct query.
Can someone help me?

Thank you

[v-xicai]

Hi @Anonymous ,

As two engineers' suggestion above, you may drag column [Year] and [Month] into Axis box of chart visual one by one, put [Number of job] into Values box, then you may use feature Drill down and Drill up to see details number for per Year and Month. There could no influence from the DirectQuery mode.

Best Regards,

Amy 

Community Support Team _ Amy

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

[Greg_Deckler]

@Anonymous - You should just be able to put Year and Month in your Axis as an ad-hoc hierarchy and then number of jobs in Values with a default SUM aggregation?

[amitchandak · Accepted solution]

@tarz, take the year, month on the axis and enlarge (The reverse square Y ) and check