Forum Discussion

jeo's avatar
jeo
Regular Visitor
2 years ago

How do i display monthly and yearly data in one graph?

Hi all,   I am trying to put to data into one graph. One data is to show the average number of work that shld be done in a month of a year and the other data shows the count of work per month. Both...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi jeo ,

If your dates are dynamic, it's going to be a pain in the ass and you'll probably need to manually specify the month each year. Other than that there is no other way.
If your data type is date-time, you can change 'Table'[Year] to 'Table'[Date]. [Year], change 'Table'[Month] to 'Table'[Date]. [Month]

Best Regards,
Dino Tao

jeo's avatar
jeo
Regular Visitor
2 years ago

Hi Anonymous ,

Alright. Thank you very much.

Best Regards,
Jeo

  • jeo's avatar
    jeo
    Regular Visitor
    2 years ago

    Hi Anonymous ,

    Is there a way to take the suggestedWI(s) and assign them to the months in the excel so it can display a line?

    Best Regards,
    Jeo

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi jeo ,

    Sorry for the late reply, but I didn't understand what you meant?

    Best Regards,
    Dino Tao

  • jeo's avatar
    jeo
    Regular Visitor
    2 years ago

    Hi Anonymous ,

     

    All good! I meant if it is possible to assign the suggestedWI(s) value of each year to the dynamic months in each year so the line graph will show a flat line over each year.

    Best Regards,
    Jeo

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi jeo ,

    Are you saying that it's like the effect provided in my first reply that shows a straight line each year instead of a point? This could theoretically be achieved using DAX, but I would need to know what your data looks like before I could attempt it.

    Best Regards,
    Dino Tao