[SOLVED] PowerBI Chart Year/Month Site by Side

PowerBI Chart Year/Month Site by Side

I am completely brand new to PowerBI and learning from YouTube. One thing I am stuck on his how to get a chart to have the previous year's month beside the current years month. This is what I currently have:

PowerBI Chart Excel Chart - What I want to achieve

Any ideas on how to do this?

Thanks, Shea

Solution

You need a month column that just has the Month name like:

Month MMM = FORMAT([Date], "MMM")

Then use this as your X-Axis.

Looking at your screenshot - it seems you have a date table or two. These most likely have one already that you can use (so long as they have the correct realtionship in place).

For sorting this new Month column, you will need another Calculated Column. Try:

MonthFY_sort = 
  var mNum = MONTH([Date])
  return SWITCH( TRUE(),
    mNum > 9, mNum - 9,
    mNum + 3
  )

Then select the Month MMM column from previous, then in the ribbon, select Sort by column and select MonthFY_sort . That should take care of the sort order starting with Oct.