creating a graph like this from excel in Power BI

[Et1w]

Hi everyone 

Does anyone know how to create a graph like like the one below in Power BI?

[TomMartens · Accepted solution]

Hey,

here you will find a little pbix file

Basically, it hust contains a Date Table, within in the table I created a column "RandomNo" that just contains a Random Number, I use the column for the value

I used the column "MonthNo" to order the "Monthname" column, from within the "Data" window --> Modeling --> Sort by column

Here is a little screenshot:

Hopefully this is what you are looking for

Regards

Tom

[Hardik]

use the line visualisation and choose month  as the axis with values 

[Et1w]

In my case i only have one measure based on months and years. Do you know if it is possbile to arrange it like in the figure?

[Hardik]

Right click on the mesure and choose date hierarchy and select month once and for the other one select year

[Et1w]

We can't insert our date value in the legend area. How did you manage to do this?