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.
I have two spreadsheets
2018 data
2019 data
When I create a clustered column chart to compare YOY by month, I run into a few issues.
Fields are populated as follows:
Axis
2018 Date of Incident (ordered by date hierarchy)
2019 Date of Incident (ordered by date hierarchy)
Value
2018 Surname of Injured Person
2019 Surname of Injured Person
When I do that, it shows the below.
2018 data is correct however 2019 is showing as 29 for all months. 29 is the number of rows, it's not actually counting the amount of 2019 incidents per month.
I'm stuck, please help! 🙂
You're going to need to combine the two sets of data somehow - either merge the queries, or create some sort of linking table listing the months. Right now I'm guessing they are separated and you just have a list of months on the 2018 table, Power BI's not going to know which of those months the 2019 data applies to so it does it for all of them
Do you know how to create a linking table listing the months?
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 |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |