Forum Discussion

jrosas20's avatar
jrosas20
New Member
5 years ago
Solved

Customize x-axis

Hi Guys 

 

I need to create date intervals (7 days)  by Month  for line chart in power bi like microsoft excel do automatically

 

In Power Bi using the same data  when I expand to day level I get all days of the month

 

 

I will appreciate your help 

 

 

 

 

 

 

Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    Hi jrosas20 ,

     

    Are you using a calendar table?

     

    This can be done using a calendar table then adding the start of week column and making an hierarchy with month, start of week and day you can have this layout.

     

     

1 Reply

  • MFelix's avatar
    MFelix
    Super User
    5 years ago

    Hi jrosas20 ,

     

    Are you using a calendar table?

     

    This can be done using a calendar table then adding the start of week column and making an hierarchy with month, start of week and day you can have this layout.