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 am attempting to make a graph of information broken down by month. The rows of the table I am using are different monthly tasks, and the columns are the count of the tasks performed by month. This graph is on a second page for drilling down to highlight a specific task. The idea is to drilldown to a task, then have a graph of the count of tasks per month in a Clustered Column Chart. I would like to have a separate "cluster" for each month, so that each is labeled accordingly. But I do not have a "month" column that I can place in the axis field. Does anyone know how I can go about doing this? The only way I know how to get it close is to add all the month columns individually to the values field, which creates one megacluster.
Below are screenshots of the data table and the graph I produced with a few of the months included.
Ideally, there would be five separate clusters here, but the months are on the y-axis, not the x-axis.
Solved! Go to Solution.
Turns out I can unpivot other columns in the Query Editor to get this to work.
Unfortunately I do not have a date column in this data set. Just the month columns which have the count of how many times each row & task has been performed in that month.
This is good to note for when I have a column of month names. However I instead have a column for every month instead. See the screenshot in my original post for what the data looks like.
Turns out I can unpivot other columns in the Query Editor to get this to work.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |