Data by day but x-axis showing week dates

[Anonymous]

I have a stacked column chart that has data by day.  The axis is date, but has month markers Jul 2020, Aug 2020, Sep 2020, Oct 2020.  I would like the x-axis to show each week, with weeks starting on a Monday, so 6th July, 13th July, 20th July etc.  I am not overly fussy on the date format so it could be 06/07/20 or 6th July 2020.  I added a new column using this formula 

Week = TRANSPORT[Date]-mod(TRANSPORT[Date]-1,7)+1.  This works but when I put this column as the x-axis, it groups the data by week, rather than showing each indiviual day.

Is it possible to do what I'm after?

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

Is this what you want?

In fact, the current version(2.85.985.0 64-bit (September 2020)) can not achieve the idea.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

it mostly depends on the number of data points you are trying to cram into the available screen real estate.  At some point Power BI will force group the items.

Try to set the X axis to categorical (instead of continuous) and see if it makes a difference.