How to show Monthly change in Line Chart without using Date/Time Intelligence

[OPS-MLTSD]

Hello,

I have a Line Chart that looks like this:

I want to show monthly data but right now the x-axis is showing bi-weekly data. 

In my x-axis, I have the Exit Date (which is in a standard date format - e.g. October 26, 2021). For my Values, I am doing a Distinct Count of Client IDs. I was wondering, is there a way to change the x-axis so that only the months are shown? So instead of having Sep 12, Sep 26, Oct 10, Oct 24, the axis should show Aug 2021, Sep 2021, Oct 2021....etc.

Please note that I have turned off Date/Time Intelligence to save space in my report. If someone could please help me figure out how to change the x-axis to show month only, that would be great. Thank you

[OPS-MLTSD]

I have not accepted a solution yet, I am not sure why this was chosen as a solution. I have tried to create a Year Month in my primary table but it did not work for me. I have other tables linked to the primary table. I have looked online to creating a separate Date Dim table, which is what I am working on right now

[v-jingzhang · Accepted solution]

Hi @OPS-MLTSD 

You can add a Year Month column to your table with "mmm yyyy" format. Use this column to replace Exit Date column on Axis.

Year Month = FORMAT('Table'[Date],"mmm yyyy")

As this Year Month column is of Text type and is sorted alphabetically, you could add another column like YearMonthNumber = YEAR('Table'[Date])*100+MONTH('Table'[Date]) and sort Year Month column by YearMonthNumber column, then it will display in month order on X axis. See Sort one column by another column in Power BI Desktop

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[OPS-MLTSD]

thank you! I will try this and get back to you shortly

[v-jingzhang]

Hi @OPS-MLTSD 

Does my solution work? Any update?

Best Regards,

Jing