Modify X axis months to Quarters on a chart

[mathieu6715]

Hello, 

Actually I try to get a chart using date datas.

Like this: 

But I want to display the quarters on the X axis not the months, to get a chart of this table:

How can I change the unit? 

Thanks you 

Mathieu

[v-lili6-msft]

hi  @mathieu6715 

Just drag Year field and Quarter in x-axis and then use Expand all fields at once of drill-model in this visual.

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill#drill-down-all-fields-at-once

Regards,

Lin

[sp8]

Same issue. When I do what you suggest, it gives me a graph that shows the month of the quarter, not the quarter number. (See below)

What I want is:

Any suggestions?

[amitchandak · Accepted solution]

@mathieu6715 , Not very clear.

refer Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M

If you have date Table. You can have Date table and use Qtr and Month from there

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-Y...


Appreciate your Kudos.