Power BI Months in Chart
-
Power BI Months in Chart
Posted by DSC Communities on December 19, 2016 at 3:26 pm-
Matthew Devall
MemberDecember 19, 2016 at 3:26 PM
All,
I’m attempting to create a chart in Power BI. When I create the axis with the months, the months go in alphabetical order instead of January thru December. How do I make the chart show January then February and so on.
I’m pulling data from an excel file. Any help if appreciated. This is my first attempt at Power BI.
——————————
Matthew Devall
Devall Towing & Boat Service of Hackberry, LLC
Sulphur LA
—————————— -
Try changing your data to 01/01/2016.
——————————
Travis Smith
WithoutWire Inventory Sciences
Minneapolis MN
————————————————————————- -
Matthew Devall
MemberDecember 20, 2016 at 6:56 AM
I did try that. That goes in the order of January then October, November, December, then back to February. It goes 1/xx, 10/xx, 11/xx, 12/xx, 2/xx, 3/xx and so on.
That’s why I switched to months. I thought it would recognize months.
I see there is a filter but I haven’t found a sort.
——————————
Matthew Devall
Devall Towing & Boat Service of Hackberry, LLC
Sulphur LA
————————————————————————- -
Mark Wiley
MemberDecember 20, 2016 at 8:25 AM
I found this:
Power BI Tips: Sort by Month Name
Data Bear remove preview Power BI Tips: Sort by Month Name Welcome to our first of the Power BI Tips series. View this on Data Bear > ——————————
Mark Wiley
Senior Consultant
Tribridge
Stow OH
————————————————————————- -
Matthew Devall
MemberDecember 20, 2016 at 12:26 PM
Mark,
I click your link and figured it out! Thank you so much.
——————————
Matthew Devall
Devall Towing & Boat Service of Hackberry, LLC
Sulphur LA
————————————————————————- -
Aaron Back
MemberDecember 20, 2016 at 8:33 AM
If the Month names are based on a date field, then create a Calculated Column and use the MONTH(<insert date field here>) formula. This will put the Month Number (1 for Jan, 2 for Feb, etc) in the column. Then use this for the Sort Column in your chart.
——————————
Aaron Back
Team Lead, IT | CareSource
Email: Aaron.Back@caresource.com
Chairman, GPUG Advisory Committee
GPUG All-Star
Summit Programming Committee
Chapter Leader, Ohio
————————————————————————- -
Anne Provost
MemberDecember 20, 2016 at 9:58 AM
For your data set, you need to create a Month in Year and Month in Year Sort column and then in Modeling, choose the Month in Year column and sort by the MonthInYearSort column.
MonthInYearSort = MONTH(‘Calendar'[Date])
Month in Year = FORMAT(‘Calendar'[Date], “MMM”)
Works great if you have a calendar year end.
——————————
Anne Provost
Chief Financial Officer
TNR Technical, Inc.
Sanford FL
————————————————————————- -
Matthew Devall
MemberDecember 20, 2016 at 12:27 PM
Everyone,
Thank you for your help. First time I ever posted a questions and will not be the last. Y’all are great!
——————————
Matthew Devall
Devall Towing & Boat Service of Hackberry, LLC
Sulphur LA
————————————————————————-
DSC Communities replied 8 years, 1 month ago 1 Member · 0 Replies -
-
0 Replies
Sorry, there were no replies found.
The discussion ‘Power BI Months in Chart’ is closed to new replies.