Combine Multiple Months data in Power Bi

[Anonymous]

Hi Team, I have data for years on months wise so how to combine years wise data in power BI. Please find below 2 screen shots from Power BI and Excel

Excel,

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

According to your description, here's my solution.

1.Select the columns from 2017/1/1 to 2017/12/1, the click unpivot columns.

2.Get three columns.

3.Created a year column.

Year = YEAR('Table'[Date])

4.Create a matrix visual, put Sales Person ID in rows, put Date and Year in columns and Value in values, then turn on the drill button.

5.Click drill down, then get the total value by year.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , In Power bi, either use the date hierarchy, option after dragging a date in visual. Right click date hierarchy .

Or in your table or date table create month year and use that

Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")

[Anonymous]

@amitchandak , i tried this way but it's not merging all the rows