Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
afleiderman1
Helper I
Helper I

How to change the x axis on a date

I am wondering how to change the  x axis spacing on one of my graph I have the following x axis

 

afleiderman1_0-1671551710137.png

But I want something  instead of by month I want something by the first day of month something like this

afleiderman1_1-1671551777225.png

But I cannot figure it out how to do this.

I have a dates column which is every 7 days 

afleiderman1_2-1671551843013.png

Not sure how to do this.

 

1 ACCEPTED SOLUTION
Shaurya
Memorable Member
Memorable Member

Hi @afleiderman1

 

Create a new column for Month Start Date.

 

Month Start = STARTOFMONTH('Table'[Date])

 

Mark this post as a solution if that works for you!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI

View solution in original post

1 REPLY 1
Shaurya
Memorable Member
Memorable Member

Hi @afleiderman1

 

Create a new column for Month Start Date.

 

Month Start = STARTOFMONTH('Table'[Date])

 

Mark this post as a solution if that works for you!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.