Power BI - X axis showing days instead of months

[kiwii]

Hello, 

I have setted autocalendar below and used column Month for X axis of a column chart.

Calendar =

 ADDCOLUMNS(

  CALENDARAUTO(),

  "Year", YEAR([Date]),

  "Month", EOMONTH([Date],-1)+1)

I want to see total of KPI per month in column chart. If I filter some category, I will get overview per days instead of months. I want to see total per month, not days. Please see the picture - there are days on X axis, I just want to see month July when category filtered.

[Idrissshatila]

hello @kiwii ,

try replacing this  EOMONTH([Date],-1)+1) with this  MONTH([Date])

[kiwii]

I already tried that but then when I change data type to Date, again I can see dates instead of months on X axis. If I leave date type Text, the formatting on X axis does not look good (see below example for Jul 2023)

[v-yiruan-msft · Accepted solution]

Hi @kiwii ,

You can follow the steps below to get it:

1. Keep the data type of the field [Date] as "Date"
2. Put the Date Hierarchy [Year] and [Month] on the visual just as below screenshot

         

If the above one can't help you get the expected result, please provide some raw data in your tables (exclude sensitive data) with Text format and your visual settings. It would be helpful to find out the solution. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards