Best approach to build a month value line chart

[Anonymous]

Hello,

For the last day I am trying a simple chart month by value for 15 months and always facing one of the following problems. Surprisingy I started to believe that Excel is much friendly than power bi... any way

When I import it from excel I get a problem that it does not show the month and the year on the chart and roll up months under one year, it also sum the same months ex Jan 19 and Jan 2020

I tried to manually input in power BI and found the following problems, I can sort the months in the chart any advices on what is the best approach?

[parry2k]

@Anonymous you have to sort your month name column with another column and in that case it will be month number. here are the steps:

- add new column in the table

Month Number = MONTH ( Table[Date] )

- select month name column 

- go to column tools on the menu and select sort by

- from drop down choose month number 

and that will do it.

I would 💖Kudos 🙂 if my solution helped. If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[Anonymous]

@parry2k  I got the attached error. I just started learning to use the software yesterday, so I have no idea what even the formula that you gave me mean. I think I need to start working on it, but why did I get the error?

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Date.Month should help you in your scenario. To create a custom column in power query like that.

Date.Month([date])

M code for your reference.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjIwtNQ3MAQipVgdGNcIiJRiYwE=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type date}}),
    #"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Column1", "date"}}),
    #"Added Custom" = Table.AddColumn(#"Renamed Columns", "Custom", each Date.Month([date]))
in
    #"Added Custom"

[Anonymous]

[parry2k]

@Anonymous ok no problem, you are in query editor, add as a dax expression, and screen shot below. You can also do in power query but let's stay out of it for now.