Forum Discussion

pedroccamara's avatar
pedroccamara
Icon for Helper II rankHelper II
10 years ago
Solved

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...
Need Help
  • BhaveshPatel's avatar
    BhaveshPatel
    10 years ago

    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.

  • Anonymous's avatar
    Anonymous
    10 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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.

BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
10 years ago

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")

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hi BhaveshPatel,

     

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

     

    Regards,

  • pedroccamara's avatar
    pedroccamara
    Icon for Helper II rankHelper II
    10 years ago

    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?

      • pedroccamara's avatar
        pedroccamara
        Icon for Helper II rankHelper II
        10 years ago

        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