Line chart - X axis formatting

[Anonymous]

Hi there!

I want to replicate the below attached excel chart in power BI

as you can see the X axis is continous but has label at interval of 6 months (its 5 year data in monthly frequency). Is there a way out to do the same in power BI charts? 

This is what I have created in power BI

This is the output when I am expanded the data to my date heirarchy (Year & month). I need to have 7 such charts on a single page hence need them to be compact.

Regards,

Saket

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

We can set categorical for the X-axis as the picture below.

[Anonymous]

Hi Saket_Casper

You can try modify the format in the table source, in the column specific or create another column with format customize.

Regards

Fernando

[Anonymous]

Hey Fernando,

Thanks for this, is there a way that I can fix the size of chart?