Power BI Months in Chart

  • Power BI Months in Chart

    Posted by DSC Communities on December 19, 2016 at 3:26 pm
    • Matthew Devall

      Member

      December 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.

      x7wBoz2mRaCAQwkjXqiA_GPUG pic.PNG

      ——————————
      Matthew Devall
      Devall Towing & Boat Service of Hackberry, LLC
      Sulphur LA
      ——————————

    • Travis Smith

      Member

      December 20, 2016 at 3:11 AM

      Try changing your data to 01/01/2016.

      ——————————
      Travis Smith
      WithoutWire Inventory Sciences
      Minneapolis MN
      ————————————————————————-

    • Matthew Devall

      Member

      December 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

      Member

      December 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

      Member

      December 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

      Member

      December 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

      Member

      December 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

      Member

      December 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 7 years, 4 months 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.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!