Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Line chart - X axis formatting

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

 

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      Hey Fernando,

       

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