Forum Discussion
Column Bar Chart Grouped by Month
Dear all,
I trust this message finds you well. I am currently working on a revenue bar chart in Power BI and have encountered an issue with the date formatting.
As it stands
the chart displays the monthly data in a sequential manner, such as Jan 21, Feb 21, Mar 21, and so on. However, I would like to display the data in a more detailed format, indicating each month for several years, such as Jan 21, Jan 22, Jan 23, Feb 21, Feb 22, Feb 23, and so forth.
I would greatly appreciate your guidance on how to achieve this formatting in Power BI. It would be helpful if you could provide any relevant tips or instructions to accomplish this task.
Thank you for your time and assistance.
Best regards,
Hi alexandreneis ,
You can create a clustered column chart as shown below: put [Month] field on X axis and [Year] field on Legend field
If there is no date hirerachy for the date field in your table, you can create calculated column as below to get them.
Year = YEAR('NOTAS'[datemi])Month = FORMAT('NOTAS'[datemi],"MMMM")Best Regards
3 Replies
Note: My data table contains this information.
Hi alexandreneis ,
You can create a clustered column chart as shown below: put [Month] field on X axis and [Year] field on Legend field
If there is no date hirerachy for the date field in your table, you can create calculated column as below to get them.
Year = YEAR('NOTAS'[datemi])Month = FORMAT('NOTAS'[datemi],"MMMM")Best Regards
I managed to align the months correctly by creating a numeric representation for each month. When I selected the 'Month Name' field, it enabled the 'Column Tools' tab. From there, I sorted the column by the numeric representation of the months, and the issue was resolved.
