Forum Discussion
Graph Axis Separate by Month
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.
5 Replies
- Do you have a date column in your data set? If yes, so you can use month hierarchy only in your clustered column chart.
Don't forget to give thumbs up 👍and accept this as a solution if this helps you.- You can go to model view then choose sort by column and then select Month Name. Refer below link to get more deets on your requirement.
https://www.c-sharpcorner.com/article/sort-by-month-name-in-power-bi/
Don't forget to give thumbs up 👍 and accept this as a solution if this helps you.
