Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
@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 🙂
⭕ 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?
Location | 1 March | 2 March | 3 March |
Location 1 | 5 | 6 | 4 |
Location 2 | 12 | 2 | 2 |
@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
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |