cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pedroccamara Regular Visitor
Regular Visitor

display date in graph like "mmm"

Hi everyone

My date field is properly formated as dd-mm-yyyy.

But on graphics i would like to only show "mmm" for month in order to get a smaller report.

Is this possible? How?

Many thanks to you all

Regards

Pedro

4 ACCEPTED SOLUTIONS

Accepted Solutions
BhaveshPatel Super Contributor
Super Contributor

Re: display date in graph like "mmm"

Either you can create a new calculated column and use format function or

 

Go to the Query editor, Select the Transform Tab and in the fifth section (Date & Time Column), Select Date drop down , Go to the Month and Select fifth option "Name of Month", Load the Query after you are done.

 

This is easy and just few clicks on the ribbon.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post

hemantsingh Member
Member

Re: display date in graph like "mmm"

Hi @pedroccamara,

 

  You can use calculated column for this purpose.

 

monthname = text(date,"mmm")

 

    where monthname is the name of the calculated column,date is the is the name of the column which is carrying all qualified dates.

 

Hope it helps.

View solution in original post

eduardo Regular Visitor
Regular Visitor

Re: display date in graph like "mmm"

Hi Pedro,

 

u can create a new column like this:

 

 colunaCalendario.png

 

You can make a new table calendar. See this video (in portuguese)

 

https://www.youtube.com/watch?v=1_CG6W_ypgk

 

 

EDIT. to order by month see this one

https://www.youtube.com/watch?v=BEz38TAROuQ&t=14m57s

 

abs

eduardo

View solution in original post

Highlighted
eduardo Regular Visitor
Regular Visitor

Re: display date in graph like "mmm"

11 REPLIES 11
BhaveshPatel Super Contributor
Super Contributor

Re: display date in graph like "mmm"

Either you can create a new calculated column and use format function or

 

Go to the Query editor, Select the Transform Tab and in the fifth section (Date & Time Column), Select Date drop down , Go to the Month and Select fifth option "Name of Month", Load the Query after you are done.

 

This is easy and just few clicks on the ribbon.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post

hemantsingh Member
Member

Re: display date in graph like "mmm"

Hi @pedroccamara,

 

  You can use calculated column for this purpose.

 

monthname = text(date,"mmm")

 

    where monthname is the name of the calculated column,date is the is the name of the column which is carrying all qualified dates.

 

Hope it helps.

View solution in original post

BhaveshPatel Super Contributor
Super Contributor

Re: display date in graph like "mmm"

Hi Hemant,

 

Just to Clarify, PowerBI doesn't have TEXT Function like Excel. DAX has FORMAT Function and the Syntex for this function is similar to TEXT Function in Excel. 

 

MONTH NAME=FORMAT(TABLE[COLUMN NAME], "MMM")

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
hemantsingh Member
Member

Re: display date in graph like "mmm"

Hi @BhaveshPatel,

 

  Thanks for clarifying. I took it mistakenly as excel formula.

 

Regards,

pedroccamara Regular Visitor
Regular Visitor

Re: display date in graph like "mmm"

Hi guys

You've help me a lot. Sometimes "i'm sleeping" and can't see the solution right away.

Anyway, i've done this, outside editor:

 

New date = LEFT((´name of the database'[DataCriacao].[Month]);3)

 

Because, what i realy want was only the first 3 letters from the month.

Thanks a lot 

Best regards

Pedro

pedroccamara Regular Visitor
Regular Visitor

Re: display date in graph like "mmm"

ok then.

After i've created a new column with only first 3 letters from month, they're not showing me in order....but alphabeticaly.

Can i do something about it?

eduardo Regular Visitor
Regular Visitor

Re: display date in graph like "mmm"

Hi Pedro,

 

u can create a new column like this:

 

 colunaCalendario.png

 

You can make a new table calendar. See this video (in portuguese)

 

https://www.youtube.com/watch?v=1_CG6W_ypgk

 

 

EDIT. to order by month see this one

https://www.youtube.com/watch?v=BEz38TAROuQ&t=14m57s

 

abs

eduardo

View solution in original post

pedroccamara Regular Visitor
Regular Visitor

Re: display date in graph like "mmm"

Olá Eduardo

The problem is that when i get my report, month in columns and the detail next on lines, it shows me (on columns) first April, August, etc. instead of Jan, Feb, etc.

That means still in the same way as b4.

At least i've learn how to do a calendar file.

And yes i did associate that new calendar table to the other one and use the new column (mmm).

But it didn't work.

Did i miss something?

 

Obrigado

1 abc

Pedro

Highlighted
eduardo Regular Visitor
Regular Visitor

Re: display date in graph like "mmm"

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,967)