Grouping dates in to calendar months

[44Bailey]

Hello,

Fairly basic PBi knowledge and I'm struggling to work this out and would appreciate any advice please.

I have a list of locations in column A.  I then have individual dates 1st March to present day in columns to the right.

Where these locations and dates meet there are there is a number to reference how many per day, per location.

In Power Bi I would like to produce reports on these numbers by Location and Date (Month).  For example I would like a Line graph with the months in the Axis (March - Oct) and the Locations in the Legend.

Is this possible, if so, an idiots guide would be much appreciated.

Thank you in advance!

[Fowmy]

@44Bailey 
Please check the attached file, you can download the file: HERE

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[44Bailey]

Hi @Fowmy  Thanks for this. My issue is that the spreadsheet I need to use is set out as per below.  INstead of all the dates being in 1 column, they are in individual columns to enable multiple locations to have numbers on each day.  Is there a way to group these dates then creat the ling graph you sent me?

Location	1 March	2 March	3 March
Location 1	5	6	4
Location 2	12	2	2

[Fowmy]

@44Bailey

You must unsymify the data so that the location and date become two columns:

See this video: https://www.youtube.com/watch?v=Vff2kRBM95o&t=3s

________________________

If my answer was helpful, consider Accepting it as the solution to help other members find it

Click the Thumbs-Up icon if you like this answer 🙂

YouTube LinkedIn two columns, please check the video.

https://www.youtube.com/watch?v=IULqUeYEnto&t=25s