Forum Discussion
Creating a Normalized Tabled with daily rows over the course of a year
- 8 years ago
Although I had a couple users help me out with this, no one really got me the solution I was looking for. I ended up sorting it out on my own as follows:
1. Manually (what I was trying to avoid) created a "Normalized" tab in my data source, excel and copy/pasted the data from each year into it's own column. Created a column along the left numbered 1 - 365 to represent the days of the year (there doesn't seem to be a date format allowing no year to be represented).
2. Within PowerBI generate a "Running total" measure using the category of interest and "Day of Year" which is what I'd called the numbered day column
Then you are able to plot multiple categories on one graph as follows:
Idealy I'd like to have the numbers at the bottom show up more like Jan 1, Feb 1, March 1, etc. but am not sure how. For the mean time this is a 90% solution to my original problem.
Hi DataGeo
Check this pbix. Tell me if this is what you're looking for
https://1drv.ms/f/s!AuU-Ye8UGM4Rko0dyKxTaxuA6pAP8A
BILASolution
Hi Bila,
I think this visualization is close, but what I will need to do is extract data from the original table to create the "normalized table".
One difference is I want to have separate lines with colors by each year, see example here:
- BILASolution8 years ago
Solution Specialist