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 ...
Turns out I can unpivot other columns in the Query Editor to get this to work.
Tahreem24
Super User
Super UserDo 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.
Don't forget to give thumbs up 👍and accept this as a solution if this helps you.
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.
- Tahreem24You 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.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.