Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
44Bailey
New Member

Grouping dates in to calendar months

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!

3 REPLIES 3
Fowmy
Super User
Super User

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

 

Fowmy_0-1603998516614.png

 

________________________

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

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

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?

 

Location1 March2 March3 March
Location 1564
Location 21222

@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

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors