Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
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
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 used
detailed data level
Data: timestamp
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
Hi Angelia,
Thanks for your reply. I'll try to find another way.
Jasper
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
71 | |
54 | |
38 | |
31 |
User | Count |
---|---|
71 | |
64 | |
60 | |
50 | |
45 |