Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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
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 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")
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?
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
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
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
Hi again Eduardo
Please forget my last message.
It's working now.
Don't know what happened but i've done again the month number and the month name and it's working great!!.
Many thanks for your pacience.
Best regards
Pedro
Olá Eduardo
Many thanks for your help. Very nice and simple....BUT!
It gives me an error...maybe beacause i have sales on the same day and the error says something like..." it's not possible to sort the column "MES_MMM" by "MesN". You cannot have more than one value in "MesN" for the same value in "MES_MMM". Choose a different column to sort or refresh data in "MesN".
This happens all in the same table because i've created 2 new columns, or for month number and the other for month name.
Any ideas left?
Many thanks for your help Eduardo
Best 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 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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |