cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Fernando92 Frequent Visitor
Frequent Visitor

Re: How do you display both years and months in x-axis?

I have chart in excel, in x-axis displayed Year, Week and Day, How I can do it in Power BI?

x-axis.PNG

Highlighted
Ed_Had Visitor
Visitor

Re: How do you display both years and months in x-axis?

Hi,

You can try "Groups". It worked for me and it doesn't need additional measures:

Pic.PNGpic2.PNGpic3.PNG

 

ezabel Frequent Visitor
Frequent Visitor

Re: How do you display both years and months in x-axis?

This works for me, but I'd like to have the month name instead of number. I made it that way, but then it can't be sorted ascending, do you know of a work around for this?

Sikku Frequent Visitor
Frequent Visitor

Re: How do you display both years and months in x-axis?

Dear Ezebel, 

 

Please, create a Calendar Date table by copying the content from the query and paste it in your 'Advanced Editor' (Inside the Query Editor > Home) to create one. When you've created it, you'd be able to see the Fiscal Month and Calendar Month in the table. Please, choose the Fiscal Month and drop it in the Shared Axis to view the month in the Month Format. It always starts with January ends and with December. 

https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-2-fiscal-columns

 

Kindly, feel free to ask me up for any clarifications.

 

Sikku Peter. 

Sikku Frequent Visitor
Frequent Visitor

Re: How do you display both years and months in x-axis?

 Dear Fernado, 

 

I hope you're problem got fixed up a long time back. Even now, you can cross check it with the following URL to create a simple Calendar Date table. It's really gonna fix your issue. 

 

Feel free to ask me up for any clarifications. 

Thank you and have a great day!

 

Best regards, 

 

Sikku Peter.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 53 members 1,162 guests
Please welcome our newest community members: