Forum Discussion
Helper IIdisplay 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
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.
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.
Hi Pedro,
u can create a new column like this:
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
creat a column number of month
https://www.youtube.com/watch?v=BEz38TAROuQ&t=7m10s
order by
https://www.youtube.com/watch?v=BEz38TAROuQ&t=14m40s
abs
eduardo
12 Replies
- BhaveshPatel
Super User
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.
pedroccamaraHi 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
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
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")
Hi, I realize this is an older inquiry, but perhaps my response can still be helpful to someone. There's a straightforward method to achieve what you need.
Step 1: Prepare your data. In Data Transform mode, navigate to your data column and extract the first month's name and its corresponding number. (You may need to duplicate the column to retain the original data after extraction.) If the data you want to display doesn't start from January but, for example, from April, you can add a custom column. This column will appropriately reorder the month numbers, assigning April as 1, May as 2, and so forth.
(= IF [month_number] >= 4 THEN [month_number] - 3, ELSE IF [month_number] < 4 THEN [month_number] + 9, ELSE NULL)
Ensure this column is formatted as a numerical column.
Step 2: Go to the Visualizations tab and drag the month_name variable to your x-axis tab.
Step 3: Navigate to the Column Tools tab. The simplest way is to click on your month_name column's name in the data panel. When the Column Tool ribbon appears, go to the 'Sort by column' tab, and select the custom column you created in step 1.
credits to awesomebisklls (https://www.youtube.com/watch?v=3ZDtmyCNbc8)
Have a fun