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

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.