Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a date column say - 'date_column' consists of date like - 02/19/2022 and I just want to show X axis to be like - Feb 2022, I can extract month like - Month(date_column) but how to show year as well as month. Please help to get my desired result.
MonthName(date_column) should do the trick.
Hi for bar chart its working, but I have a combo chart and its not working there, it displays dates as it is, please help
MonthName() always takes a date and churns out a month and year (with the underlying value of the first of that month). This isn't related to the chart type...
sir just thought to share this information -
1 - when I am using MonthName then only bar chart works properly, but combo (line chart) is not working
2 - when I am using Month(date_column) &' '& Year(date_column) then this works perfect for both the cases, but only in combo chart the sorting order gets changes
I just wanted to know what the reason behind this, just for learning purpose