cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Fernando92
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

Ed_Had
Regular 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
Regular 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

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

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
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors