Forum Discussion

Wael03's avatar
Wael03
Icon for Helper I rankHelper I
3 years ago
Solved

Display the year on a chart

Hi everyone,

 

I need your help to display the year on a chart. Let me explain :

I have selected all 2022 and 2 months from 2023:

But as you can see on the chart, it doesn't separate each year and it is adding the month when they are the same : 

Here is what I've selected as x values : 

Here is my calendar table : 

And the calculation that I've used for YearMonth column : 

YearMonth = CONCATENATE(YEAR('Calendar'[Date]),CONCATENATE("-",IF(LEN(MONTH('Calendar'[Date]))=1,CONCATENATE("0",MONTH('Calendar'[Date])),MONTH('Calendar'[Date]))))
 
Can you please help me solve this 
 
Thanks in advance !

 

 

Need Help
  • AntonioHR_'s avatar
    AntonioHR_
    3 years ago

    Hello,

     

    I think you can group your date column by month(right click and new group), then use the new column in your axis.

1 Reply

  • AntonioHR_'s avatar
    AntonioHR_
    Frequent Visitor
    3 years ago

    Hello,

     

    I think you can group your date column by month(right click and new group), then use the new column in your axis.