change x-axis labels of a clustered column chart (type continuous)

[Jasper]

Hi,

I have a data set of timestamps and emails sent. I would like to show 2 weeks of detailed data (type continuous on the x-axis) as shown in the chart below. Since the day name is relevant for the pattern I want to show "Mon 13 mrt" instead of "13 mrt" (mrt = March). How can I do that? (I tried changing data format and some calculated colums, but regrettably without succes..)

Thanks in advance!

Jasper

[v-huizhn-msft]

Hi @Jasper,

You'd better create a calculated column to get the format what you like.

format-date = FORMAT(Table1[Date],"ddd dd MMM")

Then add the format-date as x-axis level, please see the following screenshot.

If you have other issues, please feel free to ask.

Best Regards,

Angelia 

[Jasper]

Hi @v-huizhn-msft,

Thanks a lot for your reply! The suggested sollution does not fit my situation though. My data is made of timestamps and I would like to see every data point plotted (as the image below). When I use the calculated column the data gets summarized per day and the x-axis is per day, not chronological anymore. Is it possible to keep the detailed level and change the (continuous) x-axis? (to include the day abbreviation).

Best, Jasper

Calculated column useddetailed data levelData: timestamp

[v-huizhn-msft]

Hi @Jasper,

In Power BI desktop, for date value on x-asix, we can only set it as Categorical or Continuous. For your requirement, we can't achieve it.

Best Regards,
Angelia

[Jasper]

Hi Angelia,

Thanks for your reply. I'll try to find another way.

Jasper

[v-huizhn-msft]

Hi @Jasper,

Got it. Please share it if you find other solution to resolve your issue. Please feel free to ask if you have any other issue.

Best Regards,
Angelia