Forum Discussion
Week numbers as column headers? How to plot?
Greetings folks, Novice Power BI user here, tasked with figuring all of this out on behalf of ze office. I have a question for which the internet does not seem to have a solution: We have ex...
Load your Excel table into Power BI.
In Power Query Editor (Home > Transform Data):
- Select all columns that are not week numbers (e.g., Product, Region, etc.)
- Go to the Transform tab and click Unpivot Other Columns
You’ll now have:
- A column called something like Attribute (this holds your week numbers)
- A column called Value (this holds the data for those weeks)
Rename Attribute to WeekNumber and Value to something meaningful like Sales, Hours, or whatever applies.
Click Close & Apply.
Now in Power BI Report,
Create a line chart or bar chart
Drag WeekNumber to the X-axis
Drag your value field (e.g., Sales) to the Y-axis
Please check if this work,
Click on your Value field in the Y-axis section
Change "Sum" to Don’t summarize (if each week has only one value)
I tried that already, but no joy.
Now it may be possible that for some weeks, I have 2 bits of data. I'm not sure, it's quite a dataset to go through manually.