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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
KristinaSp
Helper I
Helper I

Continous x axis -how to change month name to number

Hello,

 

Maybe someone know, how to change change chart axis (continouse type), that it would show "mm/dd" (month number/day) instead of the name of rhw month.  I need that it would be "12/04", not "December 04", Dec 04" or other ways, that shows month name.

 

My date column information date type is "mm/dd" (month number/day).

 

Thank you in advance 🙂

 

Kristina

1 ACCEPTED SOLUTION
mahoneypat
Employee
Employee

Pease see this video on how to create a custom format string on a date column but have it still behave as a continous value on the axis.

 

Creating a simpler and chart-friendly Date table in Power BI - SQLBI

 

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

HI @KristinaSp,
You can create calculated columns to extract the year/month/day parts from your date field and use them to create a custom hierarchy.
Then you can use this hierarchy field on your chart and it should show the effect that you wanted.
Notice: custom data healthy not same as default date field, some features not availed on it.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
mahoneypat
Employee
Employee

Pease see this video on how to create a custom format string on a date column but have it still behave as a continous value on the axis.

 

Creating a simpler and chart-friendly Date table in Power BI - SQLBI

 

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.